/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 vote318 views1 answer
T-SQL Never ending DELETE
SQL
0 vote301 views2 answers
Clear window pl sql
SQL
0 vote319 views2 answers
Get top 1 row of each group
SQL
1 vote329 views3 answers
Divide by zero error in sql
SQL
0 vote336 views2 answers
Many to many flask-sqlalchemy
SQL
0 vote302 views1 answer
Postgresql isnull with max
SQL
0 vote372 views1 answer
Pagination with row_number
SQL
50 votes380 views4 answers
Sql alter type of column
SQL
0 vote346 views1 answer
Cartesian product sql
SQL
0 vote321 views1 answer
What is between keyword used for
SQL