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



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to