/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

22 votes141 views3 answers
Year format in date mysql
SQL
10 votes132 views4 answers
Primary key sql
SQL
0 vote118 views1 answer
Stuff in sql server
SQL
0 vote126 views1 answer
Tsql default value when no value returned by query
SQL
1 vote148 views1 answer
Insert value to new table by joining 2 different tables
SQL
0 vote122 views1 answer
Mssql current date
SQL
0 vote131 views1 answer
Mysql Selected All Duplicate Rows
SQL
0 vote191 views1 answer
Import sql dump into postgresql database
SQL
0 vote133 views1 answer
Sql datediff month
SQL
1 vote143 views1 answer
Sqlserver create table from select
SQL