select * from tablename where field NOT LIKE "%A%";

-----Original Message-----
From: Dave Carrera [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 12, 2002 12:39 PM
To: php List
Subject: [PHP-DB] Select rows where ?


Hi All
How do I select the rows that DO NOT contain a certain character.

I.e. : select * from tablename where field dose not contain "A"

Any pointers as always appreciated.

davec

Dave Carrera
Website Designer
http://www.davecarrera.com
 



-- 
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