Comparison Functions Operators MySQL Tutorial

  1. Home
  2. MySQL Tutorial
  3. Comparison Functions Operators
  4. String comparisons are not case sensitive
mysql>
mysql> SELECT 'AB' <> 'ab';
+--------------+
| 'AB' <> 'ab' |
+--------------+
|            0 |
+--------------+
1 row in set (0.00 sec)
mysql>
mysql> SELECT 'AB' = 'ab';
+-------------+
| 'AB' = 'ab' |
+-------------+
|           1 |
+-------------+
1 row in set (0.00 sec)
mysql>