Familyの中から“Joan”と音の似た姓をすべて見つけます。
SELECT family_name
FROM family
WHERE SOUNDEX(TRIM(family.family_name)) = SOUNDEX('Joan');
family_name
-----------
John
Joan
Joanne
Familyの中から“Joan”と音の似た姓をすべて見つけます。
SELECT family_name
FROM family
WHERE SOUNDEX(TRIM(family.family_name)) = SOUNDEX('Joan');
family_name
-----------
John
Joan
Joanne