Welcome to WebmasterWorld Guest from 54.166.33.25

Forum Moderators: coopster & jatar k

Mysql searching

SQL, matching characters

   
3:08 pm on Jul 12, 2008 (gmt 0)

10+ Year Member



trying to match the first 5 characters in a string is there function for this?

SELECT *
From TheTable
WHERE FirstFiveCahracters(TheTable.LookingAt) = Lookingfor

3:16 pm on Jul 12, 2008 (gmt 0)

10+ Year Member



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)

5+ Year Member



have you looked at SUBSTRING?
1:26 pm on Jul 13, 2008 (gmt 0)

10+ Year Member



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

3:03 pm on Jul 13, 2008 (gmt 0)

5+ Year Member



Something like this should work.

select * from table where LookingAt REGEXP '^0?7654'

 

Featured Threads

Hot Threads This Week

Hot Threads This Month