CODE EXAMPLE FOR SQL

mysql get first n characters of string

#get first 10 chars of string
SELECT SUBSTRING(subject, 1, 10) FROM tbl