Data Type MySQL

  1. Home
  2. MySQL
  3. Data Type
  4. 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>