[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

RE: [PHP-DB] Select rows where ?

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

Re: [PHP-DB] Select rows where ?

select * from table where columnsomething select * from table where column NOT LIKE %something% Jim Lucas - Original Message - From: Dave Carrera [EMAIL PROTECTED] To: php List [EMAIL PROTECTED] Sent: Tuesday, February 12, 2002 10:39 AM Subject: [PHP-DB] Select rows where ? Hi All

RE: [PHP-DB] Select rows where ?

:[EMAIL PROTECTED]] Sent: Tuesday, February 12, 2002 1: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