=

Overview

Equal to (if either value is NULL it returns NULL instead of 1 or 0).

See also: SQL Operators in 10.6 ES, in 10.5 ES, and in 10.4 ES

EXAMPLES

SELECT 42 = 42, 1 = 0, NULL = NULL;
+---------+-------+-------------+
| 42 = 42 | 1 = 0 | NULL = NULL |
+---------+-------+-------------+
|       1 |     0 |        NULL |
+---------+-------+-------------+

CHANGE HISTORY

Release Series

History

10.6 Enterprise

  • Present starting in MariaDB Enterprise Server 10.6.4-1.

10.5 Enterprise

  • Present starting in MariaDB Enterprise Server 10.5.3-1.

10.4 Enterprise

  • Present starting in MariaDB Enterprise Server 10.4.6-1.

EXTERNAL REFERENCES