Search words using MySQL fulltext
I have read so many query examples using mySQL and fulltext indexes,
but I am still not able to make an apparently simple query.
I would like to search a list of words (ie. 'green, black, yellow, white, orange') in text field of records, ordering results by the number of these being contained, regardless to relevance.
Just would like to list as first the record including four of the words, then the one with three and so on.
A simple query with sorted result might not be possible.But u can write a query to find the record set which contains the words u have mentioned.