sql - Simple mysql regular expression query -

i want select values first character in column equal particular character, , second character numeric [0-9] can't quite syntax.

select * table var ("r*") 

thanks,

select * table var "r%" 

http://dev.mysql.com/doc/refman/5.0/en/string-comparison-functions.html#operator_like

to check second character numeric, you'll have use regexp:

select * table var regexp "^r[0-9]" 

http://dev.mysql.com/doc/refman/5.0/en/regexp.html#operator_regexp