/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 vote312 views1 answer
Create table using the clause with as
SQL
0 vote279 views1 answer
Sql composite key
SQL
6 votes286 views2 answers
Postgresql restore from dump
SQL
0 vote287 views1 answer
Incorrect string value: '\xC4\x81ne' for column
SQL
-2 votes274 views1 answer
Remove root password mysql
SQL
5 votes265 views1 answer
Oracle scan source ddl
SQL
0 vote265 views2 answers
Get all index postgres
SQL
6 votes296 views2 answers
Sql sequence
SQL
2 votes290 views2 answers
Postgres change owner of schema
SQL
0 vote268 views1 answer
Create function syntax sql server
SQL