mysql根据某个字段去重

INSTR于sqlserver 的charindex参数相反

GROUP BY  分组去重

SELECT ugrid, ugid,userid,username,face,ctid FROM ct_usergrouprelation where   INSTR(strsql,ugid)>0   GROUP BY userid