how to query field based on first letter in mysql code example Example: mysql query first character SELECT author FROM lyrics WHERE author LIKE 'B%';