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 admin@xxxxxxxxxxxxxxxxxx -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
