/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

2 votes140 views1 answer
Oracle generated column
SQL
0 vote137 views1 answer
Dns slave zone convert
SQL
0 vote148 views1 answer
Sql Top 5 sutradara dengan filem terbanyak
SQL
0 vote149 views2 answers
How to display enum value sql server
SQL
0 vote144 views1 answer
Heidisql check how much space a row
SQL
0 vote93 views1 answer
Sqlalchemy.exc.DBAPIError: (ibm_db_dbi.Error) ibm_db_dbi::Error: SystemError('<built-in function connect> returned NULL without setting an error')
SQL
8 votes140 views3 answers
Alter user root mysql
SQL
2 votes151 views1 answer
ADD COLOUNS CREATED AND UPDATED AT IN MYSQL
SQL
3 votes134 views3 answers
Mysqldump: couldn
SQL
0 vote150 views1 answer
Changing name of column and datatype in sql
SQL