BETWEEN - database output between values
Use the following to output your data between two values:
SELECT "column_name" FROM "table_name" WHERE "column_name" BETWEEN 'value1' AND 'value2'
For example you have a people table and you want to output all guys from the age of 16 - 18:
SELECT * FROM peopletable WHERE age BETWEEN 16 AND 18
admin / Dec 07, 2003