>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 logical opertators > >thanks in advance > >jan
-- __________________________________________________ i-gap MULTIMEDIA OEG Schwingenschlögl Jan tel +43 676 545 88 31 fax +43 7442 55155 32 mailto:[EMAIL PROTECTED] http://www.i-gap.at __________________________________________________ --------------------------------------------------------------------- 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