/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 vote199 views1 answer
Cara menampilkan tabel yang tidak mengandung kata di sql server
SQL
1 vote220 views1 answer
Sqlite update from another table
SQL
0 vote198 views1 answer
Sqlite3 now
SQL
0 vote236 views1 answer
Postgresql find biggest table
SQL
0 vote211 views1 answer
Execute a stored procedure in another stored procedure in SQL server
SQL
1 vote230 views1 answer
Mysql datetime with timezone offset
SQL
7 votes206 views3 answers
How to check table name in current database sql
SQL
5 votes220 views2 answers
Get columns number sql
SQL
1 vote222 views1 answer
Get table column names sql ssms
SQL
0 vote208 views1 answer
SQL get max per id
SQL