MYSQL Query... Conditional operator

[Micah_D]

I am having trouble figuring out how to get results when I want to see is a rows field is greater than a number.

SELECT *  FROM `rate` where `status` = '2' AND where `votes` > 10 ORDER BY `average` ASC LIMIT 0, 30

any help is much appreciated!

My need is

AND where `votes` > 10 

specifically

[Pig]

what column type is votes?

[Micah_D]

small int, or int...