in() is usefull for OR ing, but is there a way to do this AND ing?
> 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
>
> ----- Original Message -----
> 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?
> > ex:
> > " WHERE mycolumn = 1 OR mycolumn = 3 OR mycolumn = 23 etc . . . "
> >
> > A thousand? How would that affect the database execution time?
> >
> >
> >
> > ---------------------------------------------------------------------
> > Before posting, please check:
> > http://www.mysql.com/manual.php (the manual)
> > http://lists.mysql.com/ (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
> >
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php