Se connecter
Inscription
Mot de passe perdu
Supprimer un message
max
tu as essayé soundex(str) ?
avec ton exemples:
renvoit 'S532' pour les quatres cas.
SOUNDEX(str)
Returns a soundex string from str. Two strings that sound almost the same should have identical soundex strings. A standard soundex string is four characters long, but the SOUNDEX() function returns an arbitrarily long string. You can use SUBSTRING() on the result to get a standard soundex string. All non-alphabetic characters in str are ignored. All international alphabetic characters outside the A-Z range are treated as vowels.
Returns a soundex string from str. Two strings that sound almost the same should have identical soundex strings. A standard soundex string is four characters long, but the SOUNDEX() function returns an arbitrarily long string. You can use SUBSTRING() on the result to get a standard soundex string. All non-alphabetic characters in str are ignored. All international alphabetic characters outside the A-Z range are treated as vowels.
avec ton exemples:
select
soundex('saint-jacques'),
soundex('saint jacques'),
soundex('saint jacque'),
soundex('saintjacque');
soundex('saint-jacques'),
soundex('saint jacques'),
soundex('saint jacque'),
soundex('saintjacque');
renvoit 'S532' pour les quatres cas.
