Bryan wrote:
If I have a SQL statement using the IN clause, how do I keep the order
of the list?
Example:
SELECT * FROM table WHERE (number in (5, 9, 3, 4, 1, 7, 2, 8, 6))
Try
SELECT * FROM table WHERE (number in (5, 9, 3, 4, 1, 7, 2, 8, 6)) ORDER
BY 5, 9, 3, 4, 1, 7, 2, 8, 6;
No idea if
Sent: Tuesday, June 26, 2007 8:01 PM
Subject: [PHP-DB] IN clause
> If I have a SQL statement using the IN clause, how do I
keep the order
> of the list?
>
> Example:
> SELECT * FROM table WHERE (number in (5, 9, 3, 4, 1, 7, 2,
8, 6))
>
> How would I pull records in the
If I have a SQL statement using the IN clause, how do I keep the order
of the list?
Example:
SELECT * FROM table WHERE (number in (5, 9, 3, 4, 1, 7, 2, 8, 6))
How would I pull records in the order of the numbers to list out as:
5 - Record 5
9 - Record 9
3 - Record 3
4 - Record 4
1 - Record 1
7