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
   
 
 
Login: 
Pass: 
 
 
     
     
2004 - 2019 / lookass.ch
makememad@lookass.ch