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 <[EMAIL PROTECTED]> 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

Reply via email to