sub_string mysql code example

Example 1: mysql get first x characters

SELECT LEFT(title , 10) FROM articles;

Example 2: mysql subst

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