Conditional ODER BY Clause HELP

Don Wieland <[email protected]> Fri, 18 Mar 2016 09:34:44 -0700

Newsgroups	gmane.comp.db.mysql.general
Message-ID	<[email protected]>

Hi gang,

Trying to get the correct syntax on this:

ORDER BY 
CASE 
	WHEN tr.Placed = "X" THEN r.Division ASC, FIELD(tr.Place,"1","2","3","4","5","6","7","8","R","WD","Exc","E","S”), tr.Score DESC 
	WHEN tr.Placed != "X" THEN tr.ride_time ASC 
END


How does one deal with CONDITION study like this?

Thanks in advance for any assistance

Don