Re: Select rows where ?
| From: | Jim Lucas [php] | Date: | Tue, 12 Feb 2002 18:50:03 +0000 |
| Subject: | Re: Select rows where ? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-16867@lists.php.net to get a copy of this message | ||
select * from table where column<>"something"
select * from table where column NOT LIKE "%something%"
Jim Lucas
----- Original Message -----
From: "Dave Carrera" <dave@davecarrera.com>
To: "php List" <php-db@lists.php.net>
Sent: Tuesday, February 12, 2002 10:39 AM
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
>
>