MySQL Tutorial/Comparison Functions Operators/Equal
Equal: =
<source lang="sql">
mysql> mysql> SELECT 1 = 0; +-------+ | 1 = 0 | +-------+ | 0 | +-------+ 1 row in set (0.00 sec) mysql> mysql></source>
SELECT "0.
<source lang="sql">
mysql> mysql> mysql> mysql> SELECT "0.0" = 0; +-----------+ | "0.0" = 0 | +-----------+ | 1 | +-----------+ 1 row in set (0.00 sec)</source>
SELECT "0.
<source lang="sql">
mysql> mysql> SELECT "0.01" = 0; +------------+ | "0.01" = 0 | +------------+ | 0 | +------------+ 1 row in set (0.00 sec)</source>
Type conversion when using the Equal operator
<source lang="sql">
mysql> mysql> SELECT "1" = 1; +---------+ | "1" = 1 | +---------+ | 1 | +---------+ 1 row in set (0.00 sec)</source>