FW: Selecting not on DB
| From: | milisphp | Date: | Thu, 21 Nov 2002 04:29:48 +0000 |
| Subject: | FW: Selecting not on DB | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-23548@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 |
+--------+
Thanks, Hansen