/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 vote211 views3 answers
Call to undefined function mysql_connect()
SQL
3 votes205 views3 answers
1396(hy00) mysql error
SQL
0 vote184 views1 answer
Insert value list does not match column list: 1136 Column count doesn't match value count at row 2"
SQL
0 vote152 views2 answers
Influxdb delete measurement based on date
SQL
1 vote132 views1 answer
Flask-sqlalchemy filter_by contains
SQL
1 vote174 views1 answer
Operator does not exist: integer = text
SQL
0 vote200 views1 answer
Shrink database file in sql server
SQL
0 vote208 views1 answer
Sql get latest of 2 datetimes
SQL
0 vote185 views1 answer
What is the difference between now() and current_date()?
SQL
0 vote184 views1 answer
Mysql where don't have string
SQL