/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

1 vote324 views1 answer
SQLite order random
SQL
0 vote328 views1 answer
Windows aggregate functions in postgresql
SQL
0 vote350 views1 answer
Select sql in descending order
SQL
0 vote336 views1 answer
FILENAME /usr/bin/mysql does not exists. Make sure correct path is set in /etc/dump admin/settings.conf.
SQL
0 vote350 views1 answer
SQL check if record exist
SQL
16 votes336 views1 answer
Mysql smallint range
SQL
1 vote343 views1 answer
Postgres set column based on another column
SQL
0 vote342 views1 answer
Geopoint from json mysql function
SQL
1 vote332 views4 answers
Aggregate function in sql
SQL
0 vote296 views1 answer
Linux upload database to mysql
SQL