The function SOUNDEX(character_expression) converts a string into a four-character code to help find similar-sounding words and names. character_expression can be a constant, variable, or column name. It is useful for finding strings for which the sound is known but the precise spelling is not. It makes assumptions about the way that letters and combinations of letters sound that can help to search out words with similar sounds.
Beekeeper Studio È Una GUI per Database Gratuita e Open Source
Il miglior strumento per query SQL ed editor che abbia mai usato. Fornisce tutto ciò di cui ho bisogno per gestire il mio database. - ⭐⭐⭐⭐⭐ Mit
Beekeeper Studio è veloce, intuitivo e facile da usare. Beekeeper supporta molti database e funziona benissimo su Windows, Mac e Linux.
The following example returns two rows containing the values ‘MacFeather’ and ‘McBadden’ in the au_lname column of the authors table. You can run this SQL statement from the SQL window in Teratrax Database Manager to get all rows where au_lname sounds like ‘mcfeather’.
USE pubs
SELECT *
FROM authors
WHERE SOUNDEX(au_lname) = SOUNDEX('mcfeather')
If you don’t have the pubs database on your server, you can experiment with some of the tables in other databases. Substitute all lowercase words with your own words.
