Monthly Archives: December 2004

Basic download script

Posted by timvw on December 29, 2004 None comments

Custom ordering with MySQL

Posted by timvw on December 9, 2004 None comments

As a follow up to Custom Ordering I discovered the nice Field function in MySQL. after it was mentionned on my favorite PHP Forum by Weirdan. It allows one to order a column on a custom order relation.

SELECT *
FROM foo
ORDER BY FIELD(column, 'Z', 'B', 'C')