get the first 7 chaeracters from a field in a select query php code example

Example 1: mysql get first x characters

SELECT LEFT(title , 10) FROM articles;

Example 2: mysql query first character

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