Collections:
SOUNDEX() - Soundex Encoding
How to perform Soundex encoding on a given string using the SOUNDEX() function?
✍: FYIcenter.com
SOUNDEX(str) is a MySQL built-in function that returns the Soundex coding of a given string. Soundex is a phonetic algorithm for indexing names by sound, as pronounced in English. For example:
SELECT SOUNDEX('Sophia'), SOUNDEX('Sofia'); -- +-------------------+------------------+ -- | SOUNDEX('Sophia') | SOUNDEX('Sofia') | -- +-------------------+------------------+ -- | S100 | S100 | -- +-------------------+------------------+
Reference information of the SOUNDEX() function:
SOUNDEX(str): code Returns a soundex string from str, or NULL if str is NULL. Two strings that sound almost the same should have identical soundex strings. Arguments, return value and availability: str: Required. The string that will be Soundex encoded from. code: Return value. The Soundex code of the given string. Available since MySQL 5.7.
⇒ SPACE() - Repeating Space Character
⇐ RTRIM() - Right-Trimming String
2023-11-13, 228🔥, 0💬
Popular Posts:
How To Select All Columns of All Rows from a Table with a SELECT statement in SQL Server? The simple...
What To Do If the StartDB.bat Failed to Start the XE Instance in Oracle? If StartDB.bat failed to st...
What Happens If the UPDATE Subquery Returns Multiple Rows in SQL Server? If a subquery is used in a ...
How To Query Tables and Loop through the Returning Rows in MySQL? The best way to query tables and l...
How To Convert Numeric Values to Character Strings in MySQL? You can convert numeric values to chara...