HeadBut
msg:3697127 | 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"
|
Chris_Mohr
msg:3697234 | 8:03 pm on Jul 12, 2008 (gmt 0) |
have you looked at SUBSTRING?
|
HeadBut
msg:3697478 | 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: 07654
7654
076541122 thanks for your help
|
Chris_Mohr
msg:3697496 | 3:03 pm on Jul 13, 2008 (gmt 0) |
Something like this should work. select * from table where LookingAt REGEXP '^0?7654'
|
|
