[PHP-DB] mySQL SELECT query

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

Re: [PHP-DB] mySQL SELECT query

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

Re: [PHP-DB] mySQL SELECT query

or NOT IN (0,4) -- matt On Fri, Aug 29, 2008 at 12:19 PM, Evert Lammerts <[EMAIL PROTECTED]>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)