I'm using soundex() in some queries, however im having a problem with composed words. For example, if i have "bird one" and i compare it to "beard" i don't get a match, but if I compare it to "beard one" it does. Now this makes perfect sense because it takes the whole word at once, but i was wondering, can't we let it check one part of a expression rather than the whole thing without having do break or anything similar?
and let's assume I have the following tableCode:SELECT name FROM animals WHERE soundex(name) = soundex("beard")
| name |