/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

2 votes340 views1 answer
Check isolation level in mysql
SQL
0 vote351 views1 answer
Django mssql backend
SQL
0 vote363 views1 answer
Generate random & unique mysql string
SQL
0 vote346 views1 answer
Create table sql generator
SQL
22 votes419 views1 answer
Mysql workbench
SQL
13 votes338 views2 answers
Check if value is null mysql
SQL
3 votes447 views1 answer
Oracle cannot access v$session
SQL
0 vote341 views1 answer
Check sql database table lock
SQL
0 vote337 views1 answer
Sql fetch next 10 rows pdo
SQL
0 vote392 views2 answers
How to truncate all table in mysql workbench
SQL