/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

7 votes246 views4 answers
Mysql delete older duplicates
SQL
0 vote193 views1 answer
How to set all the min and sec data to zero in sql server
SQL
0 vote227 views1 answer
How to check database engine in mysql
SQL
1 vote189 views1 answer
Mamp mysql path mac
SQL
8 votes193 views1 answer
Oracle add auto_increment column to existing table
SQL
0 vote180 views1 answer
Find and replace database table phpmyadmin
SQL
0 vote215 views1 answer
.sql File Run in PSQL
SQL
0 vote205 views1 answer
#1231 - Variable 'sql_mode' can't be set to the value of 'NULL'
SQL
0 vote192 views1 answer
Ms sql unique
SQL
0 vote153 views1 answer
Now() -1 mysql
SQL