在MySQL中将一个特定字母放在所有其他字母之前

Question

I am currently using:

SELECT * FROM OptSubjectItems ORDER BY yr, subject;

to get some information from a database. That works fine, except that I need to have records where yr=x first, then the others, sorted by year and subject. I tried:

SELECT * FROM OptSubjectItems ORDER BY yr=*x*, yr, subject;

from this question, but that shows things where yr=x last, rather than first.

Thanks, Jamie McClymont

Answer 1

You are nearly the solution. Just a addition

SELECT * FROM OptSubjectItems ORDER BY (yr=x) DESC, subject DESC;