[PHP-DB] mySQL SELECT query

2008-08-29 Thread Ron Piggott 
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

Re: [PHP-DB] mySQL SELECT query

2008-08-29 Thread Evert Lammerts 
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

Re: [PHP-DB] mySQL SELECT query

2008-08-29 Thread Matt Anderton 
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):

 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