> 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
