Organizational Research By

Surprising Reserch Topic

order sql by strongest like using -'mysql,sql,database,full-text-search'


order sql by strongest like  using -'mysql,sql,database,full-text-search'

I have the following query:

SELECT * FROM table_name
WHERE (col_1 LIKE '%$keyword%'
    OR col_2 LIKE '%$keyword%'
    OR col_3 LIKE '%$keyword%')
  AND .... <some optional filters> ...


is there a strategy to sort based on the most relevant results?
    

asked Sep 7, 2015 by rajesh
0 votes
19 views



Related Hot Questions

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please log in or register.

...