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