/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

8 votes195 views2 answers
Select current_timestamp - interval '3 days';
SQL
6 votes225 views3 answers
Mysql change auto_increment start value
SQL
0 vote168 views1 answer
Mysql count number of occurrences in a column
SQL
1 vote165 views3 answers
Mysql parse int
SQL
0 vote170 views1 answer
Insert overwrite table in mysql in nifi
SQL
3 votes260 views2 answers
Savepoint in sql
SQL
0 vote174 views1 answer
Delete duplicate rows
SQL
-1 vote157 views1 answer
Add column alter table default value
SQL
6 votes215 views2 answers
Return columns from table sql
SQL
0 vote191 views2 answers
Sql query print strings and int
SQL