MySQL Custom Sort

02/012007
4

Here’s something neat. If you want your SQL results in an order that’s not alphabetical or numerical, this little bit of code will allow you to specify what order you want your fields to appear.

Note that these are not in alphabetical order. You can still add other sort fields before and after this case. Pretty neat!

4 Responses

  1. Bryan
    Bryan August 25, 2008 at 7:33 pm | | Reply

    Great tip, this is exactly what I was looking for! I just wanted to pull one category to the top of the list that fell in the middle in alpha sort and this tip worked perfectly.

    Thanks for posting, I have learned MySQL through a very incremental approach and this is a great addition to my arsenal.

    Regards,
    Bryan

  2. Jamie Tibbetts
    Jamie Tibbetts December 11, 2008 at 1:48 pm | | Reply

    Genius. Thanks.

  3. Ibrahim Lawal
    Ibrahim Lawal June 1, 2011 at 9:30 am | | Reply

    This is superb! Thansk for sharing!!

  4. Dave Conan
    Dave Conan July 22, 2011 at 6:19 am | | Reply

    thanks, never thought about it before, genius,

Write a Comment