String

MD5

BigQuery

Menghitung MD5 hash dari input. Return BYTES.

Tipe hasil: BYTES

Syntax

SQL

MD5(value)

valueSTRING/BYTESwajib

Nilai yang akan di-hash

SQL

1 SELECT
2   TO_HEX(MD5('hello')) AS md5_hex,
3   MD5('hello') AS md5_bytes;

MD5 hash dari 'hello'.

Hasil

md5_hex: 5d41402abc4b2a76b9719d911017c592

SQL

1 SELECT
2   TO_HEX(MD5(CONCAT(title, content))) AS content_hash
3 FROM articles;

Generate hash untuk content deduplication.

Hasil

(content hashes)

1	SELECT
2	TO_HEX(MD5(CONCAT(title, content))) AS content_hash
3	FROM articles;