[darkfreak]

Problem: query results get ordered even though I don't want them to get.

Code:

SELECT * FROM person WHERE persID IN (202,173,437);

The above will get the result rows in ascending persID order - 173,202,437. I would like to get the result rows in the same order I've listed them in IN-part: 202,173,437.

Is it possible to tell MySQL to get the rows in my order by changing that query somehow or do I have to use another approach?

I tried the following with no success:

Code:

SELECT *,'' AS dumb FROM person WHERE persID IN (202,173,437) ORDER BY dumb;