/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 vote298 views1 answer
Geopoint from json mysql function
SQL
0 vote275 views1 answer
Drop all procedures sql server
SQL
0 vote307 views1 answer
Sql how to get courses that i have made prerequisites
SQL
0 vote298 views1 answer
Bidirectional outer join sql
SQL
14 votes299 views6 answers
Auto_increment mysql
SQL
0 vote290 views1 answer
Mysql to get column name in database
SQL
1 vote281 views1 answer
How to open closed port mysql in ubuntu
SQL
0 vote278 views1 answer
Composit key in sql
SQL
0 vote300 views1 answer
Drop database using terminal postgres
SQL
10 votes290 views2 answers
Show tables in schema oracle
SQL