/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 vote384 views1 answer
Rails sql query converstion
SQL
0 vote350 views1 answer
Drop all triggers oracle
SQL
1 vote374 views1 answer
Name of today sql
SQL
0 vote382 views1 answer
Add timestamp column to existing table t-sql
SQL
3 votes351 views1 answer
Sql datetime as date
SQL
0 vote374 views1 answer
Hoq to import database source
SQL
1 vote370 views1 answer
Python escape mysql
SQL
0 vote369 views1 answer
Get sum sqlite android
SQL
6 votes365 views1 answer
Oracle trigger after logon on schema
SQL
0 vote332 views1 answer
Couldn't execute 'SELECT COLUMN_NAME
SQL