- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- 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 use of MySQL SOUNDS LIKE operator?
As the name suggests, MySQL SOUNDS LIKE operator will search the similar sound values from a table. Its syntax is ‘Expression1 SOUNDS LIKE Expression2’ where, both Expression1 and Expression2 will be compared based on their English pronunciation of sound.
Example
Following is an example from ‘student_info’ table which will match the two expressions based on the pronunciation of sound −
mysql> Select * from student_info where name sounds like 'grov'; +------+--------+---------+------------+ | id | Name | Address | Subject | +------+--------+---------+------------+ | 105 | Gaurav | Jaipur | Literature | +------+--------+---------+------------+ 1 row in set (0.00 sec) mysql> Select * from student_info where name sounds like 'rmn'; +------+-------+---------+-----------+ | id | Name | Address | Subject | +------+-------+---------+-----------+ | 125 | Raman | Shimla | Computers | +------+-------+---------+-----------+ 1 row in set (0.00 sec)
- Related Articles
- What is the use of SOUNDS LIKE operator in MySQL?
- What is the use of MySQL NOT LIKE operator?
- Explain the use of sql LIKE operator using MySQL in Python?
- What is the use of RLIKE operator in MySQL?
- What is the use of MySQL IS and IS NOT operator?
- What is the significant difference between MySQL LIKE and equal to (=) operator?
- What is the use of EXIST and EXIST NOT operator with MySQL subqueries?
- How to use MySQL SOUNDEX() function with LIKE operator to retrieve the records from table?
- What is the use of sizeof Operator in C#?
- What is the use of tilde operator (~) in R?
- What is the operator in MySQL?
- How Are MySQL INSTR() and LIKE operator similar?
- Display specific table names with MySQL LIKE Operator
- What are the different wildcard characters that can be used with MySQL LIKE operator?
- What is the use of scope resolution operator in C++?

Advertisements