Mega Code Archive

 

Categories / MySQL Tutorial / String Functions

 

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>