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
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
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)