Welcome to WebmasterWorld Guest from

Forum Moderators: coopster & jatar k

Message Too Old, No Replies

numeric entries mysql php


nick patrick

2:16 am on Jan 13, 2009 (gmt 0)

5+ Year Member

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
`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 ?


7:20 am on Jan 13, 2009 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member

try this:

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

nick patrick

7:28 am on Jan 13, 2009 (gmt 0)

5+ Year Member

thanks it works :)

Featured Threads

Hot Threads This Week

Hot Threads This Month