/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

23 votes278 views4 answers
Sql server substring
SQL
0 vote293 views1 answer
Sql out file formate
SQL
0 vote275 views1 answer
Mysql order by where condition sub query
SQL
0 vote284 views1 answer
How to make full text search dynamic in mysql
SQL
0 vote284 views2 answers
Sqlalchemy core in clause
SQL
1 vote287 views1 answer
Sql not equal multiple columns
SQL
1 vote287 views1 answer
Mysql get domain from url
SQL
0 vote282 views1 answer
Client does not support authentication protocol requested by server sqlyog
SQL
0 vote324 views2 answers
Pl sql auto increment
SQL
1 vote332 views4 answers
How to check table in postgresql from terminal
SQL