=

Equal:

Syntax

MYSQL Copy

SELECT 1 = 0;
0
SELECT '0' = 0;
1
SELECT '0.0' = 0;
1
SELECT '0.01' = 0;
0
SELECT '.01' = 0.01;
1

Examples

Example

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

MYSQL Copy

SELECT 1 = 0;
0
SELECT '0' = 0;
1
SELECT '0.0' = 0;
1
SELECT '0.01' = 0;
0
SELECT '.01' = 0.01;
1

Example 2

MYSQL Copy

(a = x) AND (b = y)