how to sort results?

jib

Can anyone help me?

What im doing is taking a string of free text and converting it into an array, and then running an SQL query to search for any of the words that were in the string. This bit I can do fine. What I want to be able to do is then sort the result by whichever row matched the most of the words that were searched for.

For example, i run

SELECT * FROM documents WHERE content LIKE '%word1% OR '%word2%' OR '%word3%'

and i want to sort the results so the first results are the ones that contain all three words, then the rows that match 2 of the words

cheers

leatherback

Hi,

I see you have not had any replies to this problem yet. I do not know THE answer. But A solution might be: In your results, check each word independantly, add 1 for each time a search term is discovered, end then search by the number of hits?

Good luck!?

jib

hi, thanks for getting back to me, could you elaborate a little on your answer for me? cheers..

leatherback

Hi,

I have not given it that much thought to really elaborate on it. But something like..

Select * from table WHERE content LIKE '%word1% OR '%word2%' OR '%word3%'

Then, you loop through the results, and each result you search fo each of the keywords.
Check there must be something like str_match or something to find a substring in a string, or else you could use strpos: If strpos > 0 you have a mathc for the string.. Each match you get, you record, and then you order them based on the matches/.