ype tables when that happens I
don't know a work around for that either.
Best,
Yoed
-Original Message-
From: Kevin Fries [mailto:[EMAIL PROTECTED]
Sent: Monday, August 04, 2003 10:59 AM
To: 'Yoed'
Subject: RE: Order by umm OR?
Wow. Thousands of items in your IN cl
* Yoed
> Lets say I have a query similar to:
>
> SELECT * FROM company WHERE id='3' OR id='1' OR id='7' ;
>
> I want to be able to get the results to come out ordered by the order
> the ids were searched (the sequence in the WHERE OR; 3 first then 1,
> then 7...), so the results would be like:
>
>
ing WHERE id in ( '3', '1', '7') instead for brevity.
> -Original Message-
> From: Yoed [mailto:[EMAIL PROTECTED]
> Sent: Friday, August 01, 2003 12:34 PM
> To: [EMAIL PROTECTED]
> Subject: Order by umm OR?
>
>
> Hi,
>
> Lets sa
Hi,
Lets say I have a query similar to:
SELECT * FROM company WHERE id='3' OR id='1' OR id='7' ;
I want to be able to get the results to come out ordered by the order
the ids were searched (the sequence in the WHERE OR; 3 first then 1,
then 7...), so the results would be like:
Row | id|