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.

many thanks

Answers


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.


Need Your Help

Windows 10 universal app not working on windows 10 mobile

windows windows-10 windows-10-mobile

I have been working on a universal windows 10 app but when I'am testing it on my phone it is stuck on the splash screen. The app does work great on the computer.

Updating JFrame JLabel image path

java swing awt

I am reading a file path from a txt file that is constantly being created and deleted by another program, about once a second. The file path is that of an image which is then displayed in a JLabel