mysql substring index code example

Example: mysql subst

SELECT SUBSTR('This is a test!', 11, 4);