mysql substrnig code example

Example 1: mysql subquery

SELECT 
    lastName, firstName
FROM
    employees
WHERE
    officeCode IN (SELECT 
            officeCode
        FROM
            offices
        WHERE
            country = 'USA');

Example 2: mysql subst

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