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
Thanks in advance