/SQL/Mysql search like order by best match

Mysql search like order by best match

SELECT word
FROM words
WHERE word LIKE '%searchstring%'
ORDER BY
  CASE
    WHEN word LIKE 'searchstring%' THEN 1
    WHEN word LIKE '%searchstring' THEN 3
    ELSE 2
  END

Similar codes

8 votes115 views2 answers
Sqlsrv default port
SQL
1 vote105 views1 answer
How to open closed port mysql in ubuntu
SQL
1 vote119 views1 answer
How to select rows with no matching entry in another table?
SQL
42 votes139 views6 answers
Sql query duplicate rows
SQL
0 vote126 views2 answers
How to add CHECK constraint to a column in postgres
SQL
0 vote128 views1 answer
Openquery update linked server
SQL
0 vote154 views1 answer
Sql insert exemplo
SQL
1 vote131 views1 answer
Connect to mysql database ubuntu
SQL
10 votes119 views4 answers
Mysql one week ago
SQL
1 vote155 views4 answers
How to check table in postgresql from terminal
SQL