how to use substring for a column in mysql code example

Example: mysql subst

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