var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Searching partial strings with SOUNDEX()
I have done hours of searching and can not find a solution to my problem. I am attempting to do a search of usernames in a mySQL database.
For example, say I am looking for a username 'mkaminski'.
Here are the entries in the database:
A standard soundex search works great if the username is mkamynski, mkaminsky, etc. I would like to gather all the names that remotely sound the same. Now here is the problem...
I would also like to return the tables with usernames such as 'kaminski' when I search 'mkaminski'. The 'm' throws off the whole SOUNDEX search since that letter gives the word an entirely new sound.
It would be great if mysql supported using wildcards in the SOUNDEX function, so the 'kaminski' in 'mkaminski' could be matched as well as matching 'kaminsky' in 'mkaminski.'
This is frustrating
I'd appreciate any help, thanks.
try to use dis one but im not sure.
select * from tablename where fieldname like '%kmdf%'
you can compare the two soundex at first e.g.
and then if they were not the same use
select soundex('%mkaminsky%') = soundex('%kaminsky%')
may be this help!
select '%mkaminsky%' like '%kaminsky%'