[MDEV-9473] Support word-by-word on SOUNDEX() Created: 2016-01-27 Updated: 2016-01-27 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | None |
| Fix Version/s: | None |
| Type: | Task | Priority: | Trivial |
| Reporter: | David Rodrigues | Assignee: | Unassigned |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | function, soundex | ||
| Description |
|
Currently SOUNDEX() supports only single words. If is possible allow it to split each words by some character, individually, will be great. SOUNDEX('Hello World') => 'H4643' It will allow do search not related to full search (eg. tinytext) with similar words (ex. hello vs. helo) using, for instance, a LIKE. Currently I have my own implementation in a stored procedure, but it is too slow (http://pastebin.com/RhkUnjut). Then I use like: WHERE SOUNDEX(?, '%') LIKE SOUNDEX(name, '%') |