MYSQL NOT OPERATOR

I am trying to get the 'NOT' operator to work. I purchased the MYSQL bible and it had a short blurb in there about NOT but that was it.

What I am trying to accomplish is this.
I want to do a look up for a range where anything not in that range apears.

A NON working Example, IN A PERFECT WORLD WOULD LOOK LIKE THIS:
$sql = "SELECT * FROM table WHERE range !> '1' AND range !< '10'";

THE ACTULAY CODE I AM TRYING THAT IS NOT WORKING IS:
$sql = "SELECT * FROM table WHERE range NOT (range > '1' AND range < '10')";

I am using MySQL 3.23.56

1. does the NOT operator even work and if so does anyone know for what version?
2. Is there a way to accomplish this with my current version of mysql.

Thanks,

Steve

Try using NOT BETWEEN:

SELECT * FROM table WHERE range NOT BETWEEN 1 AND 10

what kind of error do you get?
tryororthese are untested ideas. use the ideas, not just the syntax :p