Re: [PHP4BETA] select troubles
| From: | Chris Adams | Date: | Wed, 19 Apr 2000 16:54:13 +0000 |
| Subject: | Re: [PHP4BETA] select troubles | ||
| References: | 1 | Groups: | php.version4 |
| Request: | Send a blank email to php-version4+get-13755@lists.php.net to get a copy of this message | ||
On 04/19/00 09:15:18 AM mike@stratabase wrote:
>Anyone know how to do select statement that has multiple conditions for one
>field?
>
>select distinct email from table
>where name like 'mic%
>email like '%.com' or email like '%.net'
Try parentheses:
SELECT DISTINCT Email FROM Table WHERE Name LIKE 'mic%' AND (Email LIKE
'%.com' OR Email LIKE '%.net')