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
Last activity: Jun 25, 2024, 02:33 PM