/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

3 votes332 views3 answers
Stop mysql ubuntu
SQL
0 vote331 views1 answer
Neo4j command to run script file
SQL
22 votes398 views4 answers
Mysql format date
SQL
1 vote323 views1 answer
Sql drop schema
SQL
0 vote331 views1 answer
Allow null in psql
SQL
1 vote743 views1 answer
Athena query timestamp greater than
SQL
0 vote288 views1 answer
Pl sql search saurce code
SQL
0 vote298 views2 answers
Mysql password error create datbase
SQL
1 vote316 views1 answer
Postgresql export output table as a csv
SQL
0 vote325 views2 answers
Script all indexes in a database
SQL