Re: Re: and statement
| From: | Larry E . Ullman | Date: | Mon, 29 Nov 2004 03:04:39 +0000 |
| Subject: | Re: Re: and statement | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-203043@lists.php.net to get a copy of this message | ||
err i mean ... an 'or' statement sry
MySQL allows SQL statements that support both AND and OR. With OR, you can often use IN instead. SELECT columns FROM tablename WHERE (condition1) AND (condition2)... All of this is in the MySQL manual, of course. Larry PS Technically speaking, this question would have been more appropriate on a MySQL list (or the PHP-DB list).is there an 'and' statement for mysql, when you are doing multiple "where"s?