homepage Welcome to WebmasterWorld Guest from 54.197.189.108
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Visit PubCon.com
Home / Forums Index / Code, Content, and Presentation / PHP Server Side Scripting
Forum Library, Charter, Moderators: coopster & jatar k

PHP Server Side Scripting Forum

    
numeric entries mysql php
nick patrick




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

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




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

try this:

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

nick patrick




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

thanks it works :)

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / PHP Server Side Scripting
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved