/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

1 vote155 views2 answers
Mysql extract month
SQL
0 vote209 views1 answer
Sql declare variable single line
SQL
0 vote157 views1 answer
Sql server alter table add column tinyint
SQL
0 vote155 views1 answer
Postgres create extension if not exists
SQL
0 vote158 views1 answer
Psotgres multiple values
SQL
1 vote202 views1 answer
Delete mysql ubuntu 20.04
SQL
0 vote154 views1 answer
Select password from user mysql
SQL
0 vote159 views1 answer
Call object contructor and call methods of object
SQL
3 votes161 views1 answer
Sql cast to integer
SQL
0 vote176 views1 answer
Selecting all columns from table sql database
SQL