numeric entries mysql php

[nick patrick]

ok my question is very simple how to get all my sql rows that Beginning with any number 0 to 9 or # not A to Z but any other
i already tried this
`row` LIKE '0%' or `row` LIKE '1%' ...... its works fie but issue is i also need a where case with like example
i need to out rows which have row2 = 5
example
`movies_title` LIKE '0%' or `movies_title` LIKE '1%' and `row2` = '5' but thats not worked its output all of row2 not the 5 only.
any help ?

[omoutop]

try this:

WHERE (`movies_title` LIKE '0%' or `movies_title` LIKE '1%') AND `row2` = '5'

[nick patrick]

thanks it works :)