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, 224🔥, 0💬
Popular Posts:
How AdventureWorksLT tables are related in SQL Server? There are 12 user tables defined in Adventure...
How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...
How To Verify Your PHP Installation in MySQL? PHP provides two execution interfaces: Command Line In...
How to download and install Microsoft .NET Framework Version 2.0 in SQL Server? .NET Framework Versi...
How To Drop an Index in Oracle? If you don't need an existing index any more, you should delete it w...