Re: Logicproblem in WHERE statement
| From: | Jaime A. Chavarriaga L. | Date: | Wed, 16 Jan 2002 22:27:18 +0000 |
| Subject: | Re: Logicproblem in WHERE statement | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-15899@lists.php.net to get a copy of this message | ||
Jason
> SELECT * FROM TABLE
> WHERE sex = 1 OR country = 'CA';
>
> Will select all users who are female as well as all users from Canada. You
> may get duplicate records (for people who are female and from Canada) so
you
> may want to use DISTINCT as well.
ok... you are right... but this error (duplicated rows) just can be possible
if you are selecting several tables, the data rows are not unique, or you
are making some kind of join
8-)
jaime