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>