What is the proper structure for searching within MySQL using SOUNDEX()?

Basically, SOUNDEX() function is used to return the Soundex, a phonetic algorithm for indexing names after English pronunciation of sound, a string of a string. The proper structure for searching within MySQL using SOUNDEX() is as follows −

SOUNDEX(Str)

Here, Str is the string whose SOUNDEX string is to be retrieved.

Example

mysql> Select SOUNDEX('MySQL');
+------------------+
| SOUNDEX('MySQL') |
+------------------+
| M240             |
+------------------+
1 row in set (0.00 sec)

mysql> Select SOUNDEX('harshit');
+--------------------+
| SOUNDEX('harshit') |
+--------------------+
| H623               |
+--------------------+
1 row in set (0.00 sec)

mysql> Select SOUNDEX('hrst');
+-----------------+
| SOUNDEX('hrst') |
+-----------------+
| H623            |
+-----------------+
1 row in set (0.00 sec)

The result of SOUNDEX(‘harshit’) and SOUNDEX(‘hrst’) is same because the sound of both the words is same.

Alankritha Ammu

Updated on 20-Jun-2020 11:04:34

• Related Questions & Answers
• Finger Searching in Data Structure
• Searching a Graph in Data Structure
• Adding and searching for words in custom Data Structure in JavaScript
• How to query soundex() in MySQL?
• What is the structure for On-Line Analytical Mining?
• What is the proper declaration of main in C++?
• What is the computer structure?
• What is the syntax for defining the data structure in C++?
• What is the proper way to insert an IF statement into a MySQL query?
• What is the proper way to retrieve the value stored in INT column as MySQL TIMESTAMP?
• Searching multiple columns for a row match in MySQL
• Set search feature in MySQL for full text searching
• What is the I/O structure?
• What is the operating system structure?
• Elements of Capital Structure that require proper analysis and scrutiny