PHP Where Problem

Hey guys,

I have a form which gets an age range for example from 18 to 30. I have a database full of users and I want to narrow down only the users from the ages of 18 to 30.

Is there any where to write something like this

SELECT * FROM `users` WHERE age='18' TO '30' ?

Or something similar to this?

Thanks,
Cezary

 

I think it's something like this:
SELECT * FROM `users` WHERE age>='18' AND age <= '30'

 

Works perfectly. Thanks