/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

0 vote122 views1 answer
Dapper run sql script with parameters
SQL
7 votes133 views2 answers
Postgres concat
SQL
3 votes115 views2 answers
WhereIn SQL
SQL
1 vote137 views2 answers
End mysql command
SQL
1 vote132 views1 answer
Delete dublicate rows sql
SQL
1 vote119 views1 answer
Sql delete all values in a column
SQL
0 vote113 views1 answer
Drop specific row postgresql
SQL
3 votes116 views1 answer
Mysql set field unique
SQL
-1 vote113 views8 answers
Create Trigger in phpMyAdmin
SQL
1 vote155 views1 answer
Size of all tables in a schema oracle
SQL