摘要：
LOCATE(substr,str) select a.name from tb_xs a where a.name like concat(a.name2,'%') 阅读全文
摘要：
查看哪些字段重复和重复几次 select dwmc,count(*) as c from table_dw group by dwmc having c>1 显示重复字段的所有信息 select *from table_dw where dwmc in (select dwmc from table 阅读全文