/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 vote399 views2 answers
Mysql show foreign keys
SQL
0 vote328 views1 answer
Bigquery information_schema schema all columns
SQL
0 vote401 views1 answer
Create a plsql object
SQL
0 vote331 views1 answer
Mysql:5.6 syntax create table
SQL
7 votes400 views1 answer
Oracle pagination query rownum
SQL
10 votes342 views2 answers
Sql rtrim
SQL
0 vote375 views1 answer
Sql sum if
SQL
2 votes355 views1 answer
Mysql virtual column
SQL
1 vote385 views1 answer
Update foreign key value in mysql
SQL
0 vote336 views2 answers
Show slave status mysql
SQL