String MySQL

  1. Home
  2. MySQL
  3. String
  4. The following comparison produces a result that is correct in lexical terms but incorrect in temporal terms
mysql>
mysql>
mysql> SELECT RIGHT('1987-7-1',5) < RIGHT('1987-10-01',5);
+---------------------------------------------+
| RIGHT('1987-7-1',5) < RIGHT('1987-10-01',5) |
+---------------------------------------------+
|                                           0 |
+---------------------------------------------+
1 row in set (0.00 sec)
mysql>