You could create an auxiliary table nb_1_10 containing a field nb with all integers from 1 to 10 Then perform a SELECT join: SELECT nb_1_10.* FROM ABC, nb_1_10 WHERE nb_1_10.nb NOT IN ABC.number AND < some condition that returns only one row from ABC - like here (1,4,6,10) > Ignatius ____________________________________________ ----- Original Message ----- From: "milisphp" <milis@indoinformatika.com> To: <php-db@lists.php.net> Sent: Thursday, November 21, 2002 5:29 AM Subject: FW: Selecting not on DB > 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 > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
