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
