Gerald Clark wrote:
> >> You might want to try:
> >>
> >> WHERE mycolumn in (1, 3, 23, ...)
> >>
> >> Or even better, put your thousand records into a temporary table and then
> >
> > just do a join.
> >
> >> --jfarr
I have yet to have a query that is to long when talking to MySQL via DBD, howev
e -
> From: "Mysql List" <[EMAIL PROTECTED]>
> To: "mysql" <[EMAIL PROTECTED]>
> Sent: Wednesday, September 26, 2001 12:06 PM
> Subject: How many OR, AND in a query?
>
>
> > Hi,
> > How many OR or AND can I put in a select query statement?
t your thousand records into a temporary table and then
>
> just do a join.
>
>> --jfarr
>>
>> - Original Message -
>> From: "Mysql List" <[EMAIL PROTECTED]>
>> To: "mysql" <[EMAIL PROTECTED]>
>> Sent: Wednesday,
If you use just 1 OR you will force a table scan and slow everything down ?
- Original Message -
From: "Mysql List" <[EMAIL PROTECTED]>
To: "mysql" <[EMAIL PROTECTED]>
Sent: 26 September 2001 20:06
Subject: How many OR, AND in a query?
> Hi,
> Ho
t: Wednesday, September 26, 2001 12:06 PM
Subject: How many OR, AND in a query?
> Hi,
> How many OR or AND can I put in a select query statement?
> ex:
> " WHERE mycolumn = 1 OR mycolumn = 3 OR mycolumn = 23 etc . . . "
>
> A
Hi,
How many OR or AND can I put in a select query statement?
ex:
" WHERE mycolumn = 1 OR mycolumn = 3 OR mycolumn = 23 etc . . . "
A thousand? How would that affect the database execution time?
-
Before posting, please chec