MySQL子查询

SELECT SUBSTRING(REPLACE(REPLACE(REPLACE(REPLACE(do,'B',''),'.','0'),'_','1'),'-','1'),1,32),B.id,B.du,B.phone,B.createdate,B.modifydate FROM ca.pro  AS BWHERE SUBSTRING(REPLACE(REPLACE(REPLACE(REPLACE(do,'B',''),'.','0'),'_','1'),'-','1'),1,32) IN (SELECT A.do1 FROM (SELECT SUBSTRING(REPLACE(REPLACE(REPLACE(REPLACE(do,'B',''),'.','0'),'_','1'),'-','1'),1,32) AS do1,COUNT(*) AS count1 FROM ca.proGROUP BY SUBSTRING(REPLACE(REPLACE(REPLACE(REPLACE(do,'B',''),'.','0'),'_','1'),'-','1'),1,32)HAVING COUNT(*) >1) AS A)