mysql concat筛选查询重复数据

SELECT c from
(SELECT *,concat(field0,field1)as c from tableName) tt
GROUP BY c HAVING count(c) > 1