Re: [mysql] Multiple WHERE options in SELECT

2002-03-14 Thread denonymous
From: "schwingenschloegl jan" <[EMAIL PROTECTED]> > >i wonder if its possible to perform multiple WHERE statements in one > >mysql SELECT statement like: > > > >SELECT * FROM table WHERE field1=3D'one' AND field2=3D'two' OR > >field3=3D'three'; > > > >it works with as many AND and > >it works wit

Re: [mysql] Multiple WHERE options in SELECT

2002-03-14 Thread DL Neil
Jan, >i wonder if its possible to perform multiple WHERE statements in one >mysql SELECT statement like: > >SELECT * FROM table WHERE field1=3D'one' AND field2=3D'two' OR >field3=3D'three'; > >it works with as many AND and >it works with OR but not together > >is there something like brackets or

[mysql] Multiple WHERE options in SELECT

2002-03-14 Thread schwingenschloegl jan
>i wonder if its possible to perform multiple WHERE statements in one >mysql SELECT statement like: > >SELECT * FROM table WHERE field1=3D'one' AND field2=3D'two' OR >field3=3D'three'; > >it works with as many AND and >it works with OR but not together > >is there something like brackets or other