Re: Which query is more correct?
| From: | Nisse Engström | Date: | Fri, 20 Nov 2009 23:36:36 +0000 |
| Subject: | Re: Which query is more correct? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-300002@lists.php.net to get a copy of this message | ||
On Fri, 20 Nov 2009 16:41:58 -0600, LAMP wrote:
> SELECT r.*
> FROM registrants r
> where r.reg_status=1 AND r.reg_id NOT IN (SELECT tbrc_reg_id FROM
> toberecleared)
>
>
> SELECT r.*
> FROM registrants r
> where r.reg_status=1 AND (SELECT count(*) FROM toberecleared where
> tbrc_reg_id=r.reg_id) = 0
>
> I checked explain of bot queries - but can't "read" them. :-)
Like Ashley, I'd probably go with the first one. The other
one seems a little backwards. Out of curiosity, what *does*
EXPLAIN say about them?
/Nisse