/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 vote148 views1 answer
Mysql query to add hours to column in table
SQL
0 vote146 views1 answer
MySQL error code 2068
SQL
0 vote142 views1 answer
Java input type sql date
SQL
3 votes139 views1 answer
Sql multiple column index
SQL
0 vote136 views1 answer
How to to get current date and time in sql
SQL
2 votes158 views1 answer
Mysql select default if null
SQL
1 vote173 views1 answer
Oracle columns table
SQL
1 vote129 views4 answers
Sql now
SQL
0 vote154 views1 answer
Datatables server side filter where clause
SQL
1 vote147 views1 answer
Oracle difference between two dates in years
SQL