<=>

Sama dengan NULL-aman. Operator ini melakukan perbandingan kesetaraan seperti operator =, tetapi mengembalikan 1 daripada NULL jika kedua operan adalah NULL, dan 0 daripada NULL jika salah satu operan adalah NULL.

Syntax

MYSQL Copy

SELECT 1 <=> 1, NULL <=> NULL, 1 <=> NULL;
1, 1, 0
SELECT 1 = 1, NULL = NULL, 1 = NULL;
1, NULL, NULL

Contoh

Example

The operator is equivalent to the standard SQL IS NOT DISTINCT FROM operator.

MYSQL Copy

SELECT 1 <=> 1, NULL <=> NULL, 1 <=> NULL;
1, 1, 0
SELECT 1 = 1, NULL = NULL, 1 = NULL;
1, NULL, NULL

Example 2

For row comparisons, (a, b) (x, y) is equivalent to:

MYSQL Copy

(a <=> x) AND (b <=> y)