Check out example codes for "mysql get first x characters". It will help you in understanding the concepts better.

Code Example 1

SELECT LEFT(title , 10) FROM articles;

Code Example 2

SELECT author FROM lyrics WHERE author LIKE 'B%';

Learn ReactJs, React Native from akashmittal.com