Fields that start with a number

[harman]

I want to select only those fields that start with a number, so this is what i do:

... WHERE comp_name like '1%' OR comp_name like '2%' 
OR comp_name like '3%' OR comp_name like '4%' 
OR comp_name like '5%' OR comp_name like '6%' 
OR comp_name like '7%' OR comp_name like '8%' 
OR comp_name like '9%' ...

i tried to do it with pattern matching
WHERE comp_name LIKE '/^[0-9]/'
or
WHERE comp_name LIKE '/^\d/'

both dont work....any suggestions

[devinemke]

SELECT * FROM table WHERE comp_name REGEXP "^[0-9]"

[harman]

thanks man...mucho grasees`