RE: [PHP-DB] FW: Selecting not on DB
| From: | John W. Holmes | Date: | Fri, 22 Nov 2002 01:42:03 +0000 |
| Subject: | RE: [PHP-DB] FW: Selecting not on DB | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-23584@lists.php.net to get a copy of this message | ||
> Hi there,
>
> I have a problem that I cannot seem to solve. I'm using MySql and
query
> it using PHP.
>
> I have create table ABC with field called "number" containing
(1,4,6,10)
>
> How is to select all number form 1 to 10 which are not
> in that field so the output somehow like this :
>
> +--------+
> | Number |
> +--------+
> | 2 |
> | 3 |
> | 5 |
> | 7 |
> | 8 |
> | 9 |
> +--------+
>
SELECT * FROM abc WHERE Number NOT BETWEEN 1 AND 10;
---John Holmes...