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