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

The Solution to MySQL Select Query - Get only first 10 characters of a value is


Using the below line

SELECT LEFT(subject , 10) FROM tbl 

MySQL Doc.

~ Answered on 2013-02-19 13:54:09


Most Viewed Questions: