[snip]
I have a query that selects a list of results, ordering them by the
status
field. However, I want to further sort that by the type of status, that
is:

Undefined
Ready for Review
Top Priority
Priority
Completed
Etc...

Every sort that I try, of course, sorts alphabetically. Is there a way
to
define how the sort function works in the order by?
[/snip]

You can specify ORDER BY foo DESC or ASC and you can do multiple ORDER
BY's

SELECT * FROM table ORDER BY foo, bar