MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: Maximum Size of Where Clause
Posted by: Paul Hartman
Date: July 25, 2005 04:00PM

You can use the "IN" option of WHERE, like:

select blah from junk where id in (1,2,3,4)

But it sounds like you definitely need a better way of accomplishing what you're tryng to do (which I'm not entirely clear on). Joins are probably where you want to head.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Maximum Size of Where Clause
Nathan Ziarek
July 25, 2005 08:55AM
Re: Maximum Size of Where Clause
Andrew Gilfrin
July 25, 2005 09:25AM
Re: Maximum Size of Where Clause
Nathan Ziarek
July 25, 2005 11:06AM
Re: Maximum Size of Where Clause
Paul Hartman
July 25, 2005 04:00PM
Re: Maximum Size of Where Clause
Nathan Ziarek
July 26, 2005 07:55AM
Re: Maximum Size of Where Clause
Paul Hartman
July 27, 2005 08:34AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.