/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 vote324 views1 answer
Python get backup of sql
SQL
0 vote258 views1 answer
Write a PL/SQL to print even numbers upto 100.
SQL
0 vote274 views1 answer
Selecting Multiple Columns in SQL
SQL
0 vote268 views1 answer
Get date ISO in psql
SQL
2 votes322 views2 answers
MySql FULL OUTER JOIN
SQL
0 vote251 views1 answer
Sql include rows with 0 values
SQL
1 vote259 views1 answer
Launch sql script from docker in mysql
SQL
0 vote256 views2 answers
Identity column in sql server
SQL
0 vote268 views1 answer
Codeigniter 3 get best-selling products
SQL
-1 vote254 views1 answer
Add bool column in sql
SQL