Re: This is really a MySQL question...

On Fri, 08 Sep 2000, Colleen R Dick wrote: > very simple question, how do you select a subset of a set > > lets say you have a set colum with possibility of a,b,c, and/ or d > > let's say you want to pull in all records where that set column contains a or b SELECT * FROM table WHERE column = 'a' OR column = 'b'; > let's say you want to pull in all records where it has both a and c Umm same as above, unless you have 2 different columns.. SELECT * FROM table WHERE column1 = 'a' AND column2 = 'c'; > I can't find this in any of my books but there must be a way to do it. You must not have very good books...unless I'm totaly not understanding your question... -- James Atkinson ----------------------------------------------------------------- James Atkinson 100world Technical Developer 512-1529 West 6th Avenue phone: +1-604-637-8122 Vancouver, BC, V6J 1R1 fax: +1-604-742-1770 Canada email: james.atkinson@100world.com http://www.100world.com +---------------------------------------------------------------+ | This message may contain confidential and/or privileged | | information. If you are not the addressee or authorized to | | receive this for the addressee, you must not use, copy, | | discolse or take any action based on this message or any | | information herein. If you have received this message in | | error, please advise the sender immediately by reply e-mail | | and delete this message. Thank you for you cooperation | +---------------------------------------------------------------+