SELECT 2 possible variables

[forumnz]

I want to select * from a database where unit is equal to either A or B. How is this done?

 

Would it be... WHERE unit BETWEEN A AND B...?

 

Thanks

Sam

[pocobueno1388]

SELECT * FROM table WHERE unit='A' OR unit='B'

[Fadion]

or you could do:

 

SELECT * FROM table WHERE unit IN ('A', 'B')

 

The "BETWEEN A AND B" isn't a correct syntax and obviously doesn't do what you want to achieve. It will find if the field is in the range of two integers. Example:

 

SELECT * FROM table WHERE id BETWEEN 10 AND 100 //will find the values of id >= 10 AND <= 100