mysql get first x characters
snippet in sql

mysql get first x characters

user5649

SELECT LEFT(title , 10) FROM articles; 

mysql query first character

user6211

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