select if rows contain morethan 1 value
SELECT `fullname`,if(count(`fullname`)>1,fullname,'NULL') as fullname FROM (SELECT * FROM `_application` ORDER BY fullname ASC) `_application` GROUP BY `fullname` ORDER BY `id` ASC