1mysql> SELECT SUBSTRING('Quadratically',5);
2 -> 'ratically'
3mysql> SELECT SUBSTRING('foobarbar' FROM 4);
4 -> 'barbar'
5mysql> SELECT SUBSTRING('Quadratically',5,6);
6 -> 'ratica'
7mysql> SELECT SUBSTRING('Sakila', -3);
8 -> 'ila'
9mysql> SELECT SUBSTRING('Sakila', -5, 3);
10 -> 'aki'
11mysql> SELECT SUBSTRING('Sakila' FROM -4 FOR 2);
12 -> 'ki'
1mysql> SELECT SUBSTRING('w3resource',4,3);
2+-----------------------------+
3| SUBSTRING('w3resource',4,3) |
4+-----------------------------+
5| eso |
6+-----------------------------+
71 row in set (0.00 sec)
8