/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 votes232 views2 answers
Postgres select duplicate columns
SQL
0 vote233 views3 answers
Database restoring error
SQL
0 vote217 views1 answer
Check psql validity function
SQL
1 vote224 views1 answer
Base nosql
SQL
1 vote222 views1 answer
Oracle grant on all tables in schema
SQL
1 vote244 views1 answer
Store select query result in variable sql server
SQL
0 vote242 views1 answer
Less than date query sqlachemy
SQL
0 vote227 views1 answer
Oracle sql alter view add column
SQL
0 vote254 views1 answer
Sql column contains special character
SQL
1 vote195 views1 answer
Insert into sql
SQL