Re: Sort (ORDER BY) by a comma-separated list of related fields using MySQL 4.1?

[Roland Bouman]

Hi!

...
ORDER BY CASE nid
WHEN 3110 THEN 1
WHEN 3060 THEN 2
WHEN 3107 THEN 3
END

(http://dev.mysql.com/doc/refman/5.1/en/control-flow-functions.html#operator_case)

or:

ORDER BY FIND_IN_SET(nid,'3110,3060,3107')

(http://dev.mysql.com/doc/refman/5.1/en/string-functions.html#function_find-in-set)

I hope this helps,

Roland Bouman
http://rpbouman.blogspot.com/