| Welcome to WebmasterWorld Guest from 126.96.36.199 |
register, login, search, subscribe, help, library, PubCon, announcements, recent posts, open posts,
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 ® and PubCon ® are a Registered Trademarks of Pubcon Inc.
© Pubcon Inc. 1996-2012 all rights reserved