mysql substring
snippet in sql

mysql get first x characters

user9825

SELECT LEFT(title , 10) FROM articles; 

mysql subst

user1986

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

mysql substring

user5560


  SUBSTRING(string, start, length)