Re: Not Like

From:	John W. Holmes	Date:	Sun, 18 Jul 2004 22:00:18 +0000
Subject:	Re: Not Like
References:	1	Groups:	php.db
Request:	Send a blank email to php-db+get-35353@lists.php.net to get a copy of this message

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