String Functions MySQL Tutorial

  1. Home
  2. MySQL Tutorial
  3. String Functions
  4. SUBSTRING(ABCDEFGHIJK FROM -4 FOR 2)
mysql>
mysql> SELECT SUBSTRING('ABCDEFGHIJK' FROM -4 FOR 2);
+----------------------------------------+
| SUBSTRING('ABCDEFGHIJK' FROM -4 FOR 2) |
+----------------------------------------+
| HI                                     |
+----------------------------------------+
1 row in set (0.00 sec)
mysql>