I have a table named Employee which contains column title and ID.
| id | Title |
|---|---|
| 1 | IHR Notification: Myanmar reported |
| 2 | Notification1: Moonmar reported with 3 cases |
now I want to search for phonetic word Myanmar but soundex function fails because it won't be able to convert some special character into its special code.
can any one suggest any other way to achieve this?