get substring from a string in mySql
mysql> SELECT SUBSTRING('w3resource',4,3);
+-----------------------------+
| SUBSTRING('w3resource',4,3) |
+-----------------------------+
| eso |
+-----------------------------+
1 row in set (0.00 sec)