Posts Tagged multi-word search

Mysql function to soundex match a word in a multi word string






soundex is a very useful mysql function when we try to compare 2 words if they sounds similar. Here is the official manual for the function. Soundex is pretty easy to use when we are comparing 2 words. For example, check the following query: select if(soundex(‘Rösle’)= soundex(‘rosle’), 1, 0); It’ll return 1 as both the […]

, ,

9 Comments