| Author |
Message |
    
Beer
Yavvanam Kaatesina Bewarse
Username: Beer
Post Number: 3533
Registered: 09-2006
Posted From: 208.204.155.241
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, February 21, 2008 - 2:11 pm: |    |
SELECT *
FROM table
WHERE SOUNDEX(substr(name,instr(name, ' '), 0, 5)) = SOUNDEX('SMITH')
OR SOUNDEX(substr(name, 0, instr(name, ' ', -1), 0, 5) = SOUNDEX('SMITH')
idi first vunna, last name vunna work avutundi
Evaro Okaru epudo kapudu nadavara munduga ato ito eto vipu |
Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma
Post Number: 6090
Registered: 06-2004
Posted From: 57.68.10.185
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, February 21, 2008 - 2:05 pm: | |
oh ardamaindi.
ippudu nenu oorike soundex('SMYTHSON') and soundex('SMITH') FROM DUAL ichi oorike chosanu. values same ravatam ledu. |
Beer
Yavvanam Kaatesina Bewarse
Username: Beer
Post Number: 3532
Registered: 09-2006
Posted From: 208.204.155.241
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, February 21, 2008 - 2:03 pm: | |
ante first name, middle name, last name lo smith ekkadavunna ee query work avutundi.
Evaro Okaru epudo kapudu nadavara munduga ato ito eto vipu |
Beer
Yavvanam Kaatesina Bewarse
Username: Beer
Post Number: 3531
Registered: 09-2006
Posted From: 208.204.155.241
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, February 21, 2008 - 2:03 pm: | |
adi space. ippud name ni split cheyyali kada. anduke instr vadi space ekkada vundo choosi antavaraku substr use chesi danini soundex to compare cheste saripotundi
Evaro Okaru epudo kapudu nadavara munduga ato ito eto vipu |
Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma
Post Number: 6089
Registered: 06-2004
Posted From: 57.68.10.185
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, February 21, 2008 - 1:59 pm: | |
SOUNDEX(name,instr(name, ' ')) = SOUNDEX('SMITH')
andulo ' ' annav ga. ala ante saripodhaa...? |
Beer
Yavvanam Kaatesina Bewarse
Username: Beer
Post Number: 3530
Registered: 09-2006
Posted From: 208.204.155.241
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, February 21, 2008 - 1:45 pm: | |
SELECT *
FROM table
WHERE SOUNDEX(name,instr(name, ' ')) = SOUNDEX('SMITH')
or SOUNDEX(name, 0, instr(name, ' ')) = SOUNDEX('SMITH')
OR SOUNDEX(name, 0, instr(name, ' ', -1)) = SOUNDEX('SMITH')
this might work
Evaro Okaru epudo kapudu nadavara munduga ato ito eto vipu |
Beer
Yavvanam Kaatesina Bewarse
Username: Beer
Post Number: 3529
Registered: 09-2006
Posted From: 208.204.155.241
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, February 21, 2008 - 1:38 pm: | |
but this will work only if there is no middle initial 
Evaro Okaru epudo kapudu nadavara munduga ato ito eto vipu |
Beer
Yavvanam Kaatesina Bewarse
Username: Beer
Post Number: 3528
Registered: 09-2006
Posted From: 208.204.155.241
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, February 21, 2008 - 1:37 pm: | |
SELECT *
FROM table
WHERE SOUNDEX(name,instr(name, ' ')) = SOUNDEX('SMITH')
or SOUNDEX(name, 0, instr(name, ' ')) = SOUNDEX('SMITH')
Evaro Okaru epudo kapudu nadavara munduga ato ito eto vipu |
Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma
Post Number: 6088
Registered: 06-2004
Posted From: 57.68.10.185
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, February 21, 2008 - 1:20 pm: | |
Oracle lo soundex functon vaadara...???
soundex and instr vaadi college ane table lo unna patrons name lo smith laaga sound ayye names anni theyali.
names are like SMYTHSON, CAROLINE L.
SMITS, CATHERINE L.
avanni raavali as they sound like smith...
evarikanna thelsa ela raayalo  |
