/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 vote170 views1 answer
Database timezone
SQL
7 votes191 views2 answers
Where keyword sql
SQL
4 votes175 views1 answer
Oracle session date format
SQL
0 vote186 views1 answer
Mysql subdate
SQL
0 vote175 views1 answer
Sql query use select name inside where clause
SQL
3 votes154 views3 answers
Docker create postgresql database
SQL
1 vote194 views1 answer
Write a query to create an empty table from an existing table?
SQL
0 vote169 views1 answer
Oracle array
SQL
0 vote170 views1 answer
Codeigniter dbforge add index
SQL
2 votes185 views3 answers
Current setting postgres timezone
SQL