

- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
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.
- 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
Advertisements