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