Welcome to WebmasterWorld Guest from 54.161.228.30

Forum Moderators: coopster & jatar k

Message Too Old, No Replies

numeric entries mysql php

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

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

5+ Year Member



thanks it works :)