Yeah, bad topic title, sorry.

I don't think this is possible, but it would be cool if it is somehow.
Let say I have the following query:

Code:
SELECT some_field, some_field2 FROM some_table WHERE some_field IN(5,4,8,2);
As I understand it, as soon as MySQL finds a row matching the IN statement, it'll be 'added' to the record set. Is there any way to have MySQL return the records ordered by the IN clause?

Something like:

Code:
some_field    some_field2
----------    --------------
5                blah
4                woo
8                eh?
2                woo 2
Instead of the following, which represents the regular sorting of the table's data:

Code:
some_field    some_field2
----------    --------------
2                woo 2
4                woo
5                blah
8                eh?
I can rearrange the result set using PHP, but I'd love to know if MySQL offers something for this

Thanks!