sorting in my_sql

[fire_cracker]

Is there any way to sort the data in a mysql query aside from ascend or decend? I want to set up a script that will have it sort it by a different letter of the alphabet depending on the day (a on monday, b on tuesday, c on wed, etc).

Thanks for the help.

[Weedpacket]

http://www.phpbuilder.com/board/showthread.php?s=&postid=10409273#post10409273

Is worth noting. I don't remember if MySQL lets you write your own functions yet to which the alternative is to write a pile of comparisons and processing (the body of the function) in the query itself.