Re: [PHP-DB] Not Like
On Sun, 2004-07-18 at 15:00, John W. Holmes wrote: > Cole S. Ashcraft wrote: > > > I am trying to figure out how to display something where the condition > > is not like im a MySQL query. The query is > > > >> select * from class where classID like '_00'order by classID; > > > > > > How would I make the like into a not like (aka negating it. The ! does > > not work)? I couldn't find anything in the MySQL manual. > > SELECT * FROM class WHERE classID NOT LIKE '_00' ORDER BY classID > > Do I get a "doh! that was obvious" prize?? ;) Sorry. Completely forgot about that. And I say I know how to use MySQL. Wow. > > -- > ---John Holmes... > > Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/ > > php|architect: The Magazine for PHP Professionals – www.phparch.com > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- This message has been scanned for viruses and dangerous content by MailScanner on mail.ashcraftfamily.net, and is believed to be clean. Please report any deviance from this condition immediately to the AFN Administrator at [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Not Like
Cole S. Ashcraft wrote: I am trying to figure out how to display something where the condition is not like im a MySQL query. The query is select * from class where classID like '_00'order by classID; How would I make the like into a not like (aka negating it. The ! does not work)? I couldn't find anything in the MySQL manual. SELECT * FROM class WHERE classID NOT LIKE '_00' ORDER BY classID Do I get a "doh! that was obvious" prize?? ;) -- ---John Holmes... Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/ php|architect: The Magazine for PHP Professionals – www.phparch.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Not Like
I am trying to figure out how to display something where the condition is not like im a MySQL query. The query is select * from class where classID like '_00'order by classID; How would I make the like into a not like (aka negating it. The ! does not work)? I couldn't find anything in the MySQL manual. Thanks, Cole -- This message has been scanned for viruses and dangerous content by MailScanner on mail.ashcraftfamily.net, and is believed to be clean. Please report any deviance from this condition immediately to the AFN Administrator at [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php