/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 vote121 views1 answer
Cara menampilkan user di mysql terminal
SQL
3 votes161 views1 answer
Define REGEXP?
SQL
7 votes137 views2 answers
Mysql db size
SQL
0 vote151 views1 answer
Oracle change password expiration policy
SQL
0 vote147 views1 answer
Count characters of string mysql
SQL
0 vote144 views1 answer
How to create a new shema using query languaage
SQL
3 votes128 views1 answer
Postgres update column with value from another table
SQL
2 votes131 views1 answer
Oracle calculated column
SQL
0 vote134 views1 answer
Use where instead of join
SQL
0 vote131 views1 answer
Table or view does not exist
SQL