# A 2nd MySQL Question **URL:** \ **Category:** programming\ **Created:** [June 1, 2009, 12:46pm UTC](https://forum.kirupa.com/t/a-2nd-mysql-question/289526 "2009-06-01T12:46:46Z")\ **Posts on this page:** 1\ **Page:** 1
**Author:** ![Nevo](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/nevo/32/3473_2.png) [@Nevo](https://forum.kirupa.com/u/Nevo)\ **Post date:** [June 1, 2009, 12:46pm UTC](https://forum.kirupa.com/t/a-2nd-mysql-question/289526/1 "2009-06-01T12:46:46Z")
Hi again, How would I go about ordering a querie’s result in the order the keywords were given? ```auto "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. ```auto 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