help Between query

I want to search user from age between 20 to 30 and gender should be male.
Please tell me the query.

 

it would help if you posted your database structure

Generally this would be

SELECT * FROM `TABLENAME` WHERE `age` > 19 AND `age` < 31 AND `gender` = 'male' LIMIT 10

 

also try it
SELECT age,gender FROM table_name WHERE age BETWEEN 20 AND 30 AND gender = 'male';

 

Thanks to both query is working.