CODE EXAMPLE FOR SQL

mysql query first character

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