MySQL SELECT Query

[berbbrown]

I have a table containing customers which has a primary key on a field called "customerid".

I have the following query:

SELECT DISTINCTROW priority, customerid
FROM tblcustomers WHERE customerid IN (10153,609,156,663,10128)

The query works but always returns the records in primary key order. I want the order in the order specified using the IN keyword as above. Is this possible with MySQL?

Please help.

Thanks in advance.

BB

[devinemke]

a bit heavy-handed, but this would work:

$order = array(10153,609,156,663,10128);
$result = mysql_query('SELECT DISTINCTROW priority, customerid FROM tblcustomers WHERE customerid IN(10153,609,156,663,10128)');
while ($row = mysql_fetch_assoc($result)) {$array[$row['customerid']] = $row;}
foreach ($order as $value)
{
	$ordered_array[$value] = $array[$value];
}
print_r($ordered_array);

[paulnaj]

You would normally use an ORDER BY clause to sort results, but this isn't going to work in your case.

What's the significance of that particular sort order? Is is something to do with the priority field?

Paul