Posted by Jerry Stuckle on 08/29/07 17:04

giloosh wrote:
> On Aug 29, 12:20 pm, Jan Thomä <k...@insomnia-hq.de> wrote:
>> giloosh wrote:
>>> Would i just loop through the rows that were checked and add them to
> Thanks Jan.
> I will do a few SQL tests to see which method is faster.
>>> the WHERE STATEMENT using the OR condition?
>>> select * from rows where id = 3 or id = 2 or id = 6 or id = 10
>> You could try the IN variant like:
>>
>> select * from rows where id in ( ?, ?, ?, ?);
>>
>> This might be a bit faster than the ORs...
>>
>> Best regards,
>> Jan
>>
>> --
>> _________________________________________________________________________
>> insOMnia - We never sleep...http://www.insOMnia-hq.de
>
>

You could even ask in a SQL group, since this isn't a PHP question.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

[Back to original message]