Manage case where lastName is one character and firstName is multiple characters

[paulalbert1]

This occurs at least ~0.03% of the time, probably more as unlikely records are discarded.

See query:

SELECT * from (
SELECT 
  a.pmid, 
  a1.personIdentifier,
  userAssertion,
  GROUP_CONCAT(distinct authorLastName SEPARATOR ', ') AS lastName, 
  GROUP_CONCAT(distinct authorFirstName SEPARATOR ', ') AS firstName
FROM 
  person_article a1
JOIN
  person_article_author a on a1.pmid = a.pmid and a1.personIdentifier = a.personIdentifier
WHERE 
  CHAR_LENGTH(authorLastName) = 1 AND 
  CHAR_LENGTH(authorFirstName) > 1
GROUP BY  
  a.pmid
) x where lastName like '%,%'