Click to See Complete Forum and Search --> : ORDER BY WHERE column = value


Dudsmack
01-03-2010, 11:29 PM
Is it possible to order a query result by a column of a specific value?

c1 | c1 | c....
a x z
b x z
c x z

For example, I'd like to be able to do something like "SELECT * FROM TABLE ORDER BY (WHERE `c1` = b) ASC;

(using MySQL)