MICKEY@STUDY

MySQL多字段重复记录筛选：select * from T_CELLID TCwhere (TC.MCC,TC.MNC,TC.LAC,TC.CELL,TC.LNG,TC.LAT) in (select MCC,MNC,LAC,CELL,LNG,LAT from T_CELLID group by MCC,MNC,LAC,CELL,LNG,LAT having count(*) > 1)...

#是否包含某串select * from  table  tt where locate('7',tt.col)>0#替换UPDATE table   SET col=REPLACE(col, '_27', '')