/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

2 votes141 views5 answers
Alter table primary key postgresql
SQL
1 vote198 views1 answer
Second last highest id in sql
SQL
0 vote341 views1 answer
Running mysql from bash sc
SQL
14 votes194 views1 answer
Oracle new column
SQL
0 vote205 views2 answers
Nested query
SQL
0 vote184 views2 answers
What is the library that should import to use all functional database features in SQLite?
SQL
13 votes177 views5 answers
Select last row mysql
SQL
51 votes585 views6 answers
Installing mysql on ubuntu
SQL
5 votes223 views3 answers
Sql limit offset
SQL
0 vote203 views1 answer
Psql no such file or directory
SQL