From the course: MySQL Essential Training (2019)
Join today to access over 22,500 courses taught by industry experts.
Soundex - MySQL Tutorial
From the course: MySQL Essential Training (2019)
Soundex
- [Instructor] The SOUNDEX functions are used to find words that sound alike in the English language. There's currently no equivalent function for other languages. For example I can say select SOUNDEX of bill, my name, and SOUNDEX of bell, which is not my name, And when I execute this you'll notice that I get the same value for both of these because they kind of sound alike. The SOUNDEX algorithm was developed in the early 20th century and has been standardized by the US National Archives and Records Administration, NARA. It's a simple phonetic algorithm that will index words together if they sound alike. So I can select SOUNDEX of ache, and SOUNDEX of ack, and when I execute this you notice they get exactly the same value. The SOUNDEX algorithm returns the initial letter, followed by a number representing the sound of the rest of the word after vowel sounds have been removed. Standard SOUNDEX is four characters long. MySQL will add additional characters by extending the algorithm. So…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.