Re: mySQL SELECT query
| From: | Matt Anderton | Date: | Fri, 29 Aug 2008 17:21:30 +0000 |
| Subject: | Re: mySQL SELECT query | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-45273@lists.php.net to get a copy of this message | ||
or NOT IN (0,4)
-- matt
On Fri, Aug 29, 2008 at 12:19 PM, Evert Lammerts
<evert.lammerts@gmail.com>wrote:
> In the SQL standard this would be
>
> AND NOT ministry_directory.listing_approved=0 AND NOT
> ministry_directory.listing_approved=4
>
> MySQL supports (and there are probably more RDBs that do):
>
> AND ministry_directory.listing_approved!=0 AND
> ministry_directory.listing_approved!=4
>
> On Fri, Aug 29, 2008 at 7:09 PM, Ron Piggott <ron.php@actsministries.org>
> wrote:
> > Is there a way to make this part of a SELECT query more concise?
> >
> > AND ministry_directory.listing_approved NOT LIKE '0' AND
> > ministry_directory.listing_approved NOT LIKE '4'
> >
> > I know of the
> >
> > IN ( 10, 12 )
> >
> > command. Is there something similar available for NOT LIKE?
> >
> > Ron
> >
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> >
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>