MySQL Select Query - Get only first 10 characters of a value

Using the below line

SELECT LEFT(subject , 10) FROM tbl 

MySQL Doc.

SELECT SUBSTRING(subject, 1, 10) FROM tbl