A 2nd MySQL Question

Hi again,

How would I go about ordering a querie’s result in the order the keywords were given?

"SELECT id, username, dob FROM `member` WHERE username in ('Churchill', 'alice')"

How would I make sure the result is ordered as Churchill first then alice as in the order above?
Currently I’m getting it backwards, initially I thought it was ordering it in the order they were founds in the table but the example here proves that to be false.


id   username          dob
2  | alice        | 1356220800
1  | Churchill    | 1356220800

Studied the order by pages on the mysql site but to no avail :frowning:
Thanks in advance