Mega Code Archive

 

Categories / MySQL / Data Type

 

If you are comparing strings and numerics, or floating-point numbers and integers, MySQL will compare them as

if they were the same type. mysql> mysql> SELECT '4200' = 4200.0; +-----------------+ | '4200' = 4200.0 | +-----------------+ |               1 | +-----------------+ 1 row in set (0.00 sec) mysql>