Skip to content
Advertisement

MySQL – ORDER BY multiple words, then alphabetically?

How can I change this part of the query to have multiple words ordered first in sequence, then the rest of the results alphabetically?

So, it needs to be:

Then all other results alphabetically.

Advertisement

Answer

You can just expand your CASE expression with each of the desired words:

User contributions licensed under: CC BY-SA
8 People found this is helpful
Advertisement