/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

1 vote188 views1 answer
Set all the vluses in calumn in sql to false
SQL
2 votes198 views1 answer
Mysql select random id from table
SQL
0 vote196 views1 answer
How to select only a certain date sql
SQL
0 vote198 views1 answer
Oracle sql generate list of days
SQL
0 vote150 views1 answer
How to get last client id sql
SQL
0 vote199 views1 answer
Having trouble running COUNT in my INSERT INTO statement
SQL
5 votes251 views4 answers
Mysql on duplicate key update
SQL
0 vote194 views1 answer
Show function mysql
SQL
1 vote194 views1 answer
Drop table if exists oracle
SQL
0 vote202 views1 answer
Restore backup mysql .gz
SQL