mysql starts with string code example Example: mysql select where starts with SELECT author FROM lyrics WHERE author LIKE 'B%';