MySQL Select Query – Get only first 10 characters of a value November 14, 2022 by Tarik Using the below line SELECT LEFT(subject , 10) FROM tbl MySQL Doc.