/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 vote158 views1 answer
Mysql check datetime equals date
SQL
16 votes171 views2 answers
Sql vs nosql
SQL
1 vote151 views3 answers
Mysql Server Start
SQL
3 votes159 views2 answers
Syntax error or access violation: 1701 Cannot truncate a table referenced in a foreign key constraint
SQL
5 votes173 views6 answers
Sql foreign key
SQL
0 vote176 views1 answer
How to add mysql to path on termin after installation
SQL
0 vote154 views7 answers
10 random questions use python and SQL
SQL
0 vote193 views1 answer
Mysql loop through databases and execute query
SQL
5 votes332 views2 answers
How to ascending order in sql
SQL
13 votes201 views6 answers
Mysql remove duplicates
SQL