/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 vote197 views1 answer
MySql get primary keys of table
SQL
0 vote190 views1 answer
Parsing float to int in mysql
SQL
3 votes247 views1 answer
Oracle nextval insert
SQL
5 votes212 views6 answers
Sql foreign key
SQL
0 vote204 views1 answer
Knex last insert id mysql
SQL
0 vote196 views1 answer
Sql grant select only
SQL
0 vote277 views1 answer
How to show current database in mysql
SQL
9 votes221 views3 answers
Where clause sql
SQL
2 votes204 views1 answer
Username sql
SQL
0 vote235 views1 answer
Mysql faster delete
SQL