[darkfreak]

Originally Posted by TizMe

Give this a whirl.
SELECT * FROM person WHERE persID IN (202) UNION SELECT * FROM person WHERE persID IN (173) UNION SELECT * FROM person WHERE persID IN (437);

Thanks. This does the trick, even though it's not very elegant if I have, say, 50-100 persons in the group

As NeverMind pointed out, this could be simplified a bit by not using the IN:

Code:

SELECT * FROM person WHERE persID=202 UNION SELECT * FROM person WHERE persID=173 UNION SELECT * FROM person WHERE persID=437;

Strangely, even the query below will order the result:

Code:

SELECT * FROM person WHERE persID=202 OR persID=173 OR persID=437;

I guess this is some MySQL query-optimization feature...?