mysql question

I realize this isn't a php question, but I figured that someone here knows of a good mysql newsgroup and in the mean time someone here probaby knows the answer to my question. Can I set up a query like this: select * from table where start_shot <= $current_shot and end_shot >= $current_shot note everything will be of type INT Thanks ya'll