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 logical opertators
There is a wealth of operators and functions (including precedence-controlling brackets). Manual: 6.3 Functions for Use in SELECT and WHERE Clauses Regards, =dn --------------------------------------------------------------------- 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