or NOT IN (0,4) -- matt On Fri, Aug 29, 2008 at 12:19 PM, Evert Lammerts <evert.lammerts@xxxxxxxxx>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@xxxxxxxxxxxxxxxxxx> > 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 > >
