Mysql Where and between query to database

Question

SELECT name, address FROM global WHERE (type=3) AND WHERE (id BETWEEN 3 and 7); syntax issue. but the idea is to only get row between 3 and 7 from the type 3 column.

I remove one of the () so WHERE(type=3) AND WHERE id BETWEEN 3 and 7. same error

Answer 1

You should use a between operator as below:

SELECT name, address FROM global WHERE type=3 
AND id BETWEEN 3 and 7;