how to get first character of a string in mysql code example

Example: mysql query first character

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