mysql search starts with code example

Example: mysql select where starts with

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