| Welcome to WebmasterWorld Guest from 220.127.116.11 |
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
|Become a Pro Member|
SQL, matching characters
| 3:08 pm on Jul 12, 2008 (gmt 0)|
trying to match the first 5 characters in a string is there function for this?
WHERE FirstFiveCahracters(TheTable.LookingAt) = Lookingfor
| 3:16 pm on Jul 12, 2008 (gmt 0)|
LIKE doesn't seem to work cause sometimes the strings LookingAt is missing the first character "0"
| 8:03 pm on Jul 12, 2008 (gmt 0)|
have you looked at SUBSTRING?
| 1:26 pm on Jul 13, 2008 (gmt 0)|
The sometimes missing first character "0" messes things up. Not sure how to get a match with SUBSTRING. It's kinda like a zip code 07654. I need to match with three conditions like:
thanks for your help
| 3:03 pm on Jul 13, 2008 (gmt 0)|
Something like this should work.
select * from table where LookingAt REGEXP '^0?7654'
All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved