String

SOUNDEX

MySQL

Mengembalikan soundex string - kode fonetik yang merepresentasikan pengucapan. Berguna untuk fuzzy matching nama.

Tipe hasil: VARCHAR

Syntax

SQL

SOUNDEX(str)

Parameter

strVARCHARwajib

String yang akan di-encode

Contoh Penggunaan

Basic Soundex

SQL

1 SELECT SOUNDEX('Robert') AS s1,
2        SOUNDEX('Rupert') AS s2;

Kedua nama memiliki soundex yang sama.

Hasil

s1: R163, s2: R163

Fuzzy Name Search

SQL

1 SELECT name, SOUNDEX(name) AS soundex_code
2 FROM customers
3 WHERE SOUNDEX(name) = SOUNDEX('Smith');

Mencari nama yang terdengar seperti 'Smith'.

Hasil

(Smyth, Smithe, Smith, etc.)

Compare Names

SQL

1 SELECT name1, name2,
2        CASE WHEN SOUNDEX(name1) = SOUNDEX(name2) 
3             THEN 'Similar' ELSE 'Different' 
4        END AS match
5 FROM name_pairs;

Membandingkan kemiripan fonetik.

Hasil

(similarity comparison)

Fungsi Terkait

REVERSEREPEATASCIICHAR

Kembali ke MySQL Functions

1	SELECT name, SOUNDEX(name) AS soundex_code
2	FROM customers
3	WHERE SOUNDEX(name) = SOUNDEX('Smith');

1	SELECT name1, name2,
2	CASE WHEN SOUNDEX(name1) = SOUNDEX(name2)
3	THEN 'Similar' ELSE 'Different'
4	END AS match
5	FROM name_pairs;