Sample Header Ad - 728x90

Sort results by number of matching words

0 votes
2 answers
432 views
I have a table (called sentences) in which I have some sentences. I want people to be able to search it with multiple words, which would make the SQL query look like this: SELECT content FROM sentences WHERE content LIKE "%%" OR content LIKE "%%" OR content LIKE "%%" etc... ; How can I sort the results by the number of occurrences of different words, the most matching sentence comes first, etc...?
Asked by loicEzt (1 rep)
Oct 20, 2020, 08:27 PM
Last activity: Jun 25, 2024, 02:33 PM