Web lists-archives.com

Re: Conditional ODER BY Clause HELP




2016/03/18 12:54 ... Don Wieland:
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?
That certainly is quite wrong. It is
ORDER BY f1 [ASC/DESC], f2 [ASC/DESC], ...
where each "f" may be a formula. This is valid:

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

but maybe you don't want that.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql