first character is character in mysql code example Example: mysql query first character SELECT author FROM lyrics WHERE author LIKE 'B%';