Which is the proper syntax to indicate I want to SELECT ALL from user_submissions where the field CAMARO_YEAR is NOT BETWEEN 1967 and 2002?
For example let's say someone put "67" or "88" or "198" or something.. It should SELECT those because it's not between "1967 - 2002"
I tried :
$sql_cal09 = "SELECT * FROM user_submissions WHERE CAMARO_YEAR NOT IN BETWEEN '1967' AND '2002' ORDER BY SUBMISSION_ID";
and
$sql_cal09 = "SELECT * FROM user_submissions WHERE CAMARO_YEAR NOT BETWEEN ('1967', '2002') ORDER BY SUBMISSION_ID";
but it's selecting ALL.. even tho the "CAMARO_YEAR" is between 1967 and 2002.. The "NOT" is not being read properly.
Thanks