Thanks, that seemed the sensible way to me as well. I just didn't know for sure if you could do that in a MySQL query for sure.
Thanks, Ed On Fri, 6 Feb 2004, John McCaskey wrote: > Yes, I think the most straight forward way is to simply put in a series of > grouped OR statements. See below. > > SELECT * from pages WHERE > changelog.agent = pages.agent AND > changelog.company = pages.company AND > changelog.magazine = pages.magazine AND > ( > changelog.orig_id = pages.mls_1 OR > changelog.orig_id = pages.mls_2 OR > changelog.orig_id = pages.mls_3 OR > changelog.orig_id = pages.mls_4 OR > changelog.orig_id = pages.mls_5 OR > changelog.orig_id = pages.mls_6 OR > changelog.orig_id = pages.mls_7 OR > changelog.orig_id = pages.mls_8 OR > changelog.orig_id = pages.mls_9 OR > changelog.orig_id = pages.mls_10 OR > changelog.orig_id = pages.mls_11 OR > changelog.orig_id = pages.mls_12 > ) > > John A. McCaskey > > > > -----Original Message----- > From: Ed Curtis [mailto:[EMAIL PROTECTED] > Sent: Friday, February 06, 2004 10:20 AM > To: [EMAIL PROTECTED] > Subject: Query matching > > > > I've been challenged to write a matching query in a project and do not know > how to handle a part of it. The criteria are as follows: > > SELECT * from pages WHERE > > changelog.agent = pages.agent AND > changelog.company = pages.company AND > changelog.magazine = pages.magazine > > Now for the challenging part for me at least. > > one of the following must at least be true for the query to return a result. > > changelog.orig_id = pages.mls_1 > changelog.orig_id = pages.mls_2 > changelog.orig_id = pages.mls_3 > changelog.orig_id = pages.mls_4 > changelog.orig_id = pages.mls_5 > changelog.orig_id = pages.mls_6 > changelog.orig_id = pages.mls_7 > changelog.orig_id = pages.mls_8 > changelog.orig_id = pages.mls_9 > changelog.orig_id = pages.mls_10 > changelog.orig_id = pages.mls_11 > changelog.orig_id = pages.mls_12 > > Would I nest these as an OR statement and how would I go about it? > > Thanks, > > Ed Curtis > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
