/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

11 votes328 views1 answer
Mysql order by two columns priority
SQL
0 vote348 views1 answer
Alter table change default
SQL
0 vote304 views1 answer
Mariadb LOAD DATA INFILE
SQL
0 vote324 views1 answer
Query to count the number of rows in a table in sqlalchemy
SQL
6 votes395 views2 answers
Oracle undotbs usage
SQL
0 vote326 views1 answer
Update view sql
SQL
1 vote336 views1 answer
Access denied for user 'root'@'localhost' python sql-connect error
SQL
0 vote354 views1 answer
Psql store procedure-return multiple table values
SQL
0 vote328 views1 answer
How to connect postgresql database with java
SQL
0 vote334 views1 answer
Where date in datetime mysql
SQL