substring_index in mysql code example

Example: mysql subst

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