manniru
7/31/2014 - 5:45 PM

select if rows contain morethan 1 value

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