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