有以下这样的mysql查询语句,请问怎么去掉重复数据
$sql="select * from ";
$sql.=" dr_member as a ,dr_member_data as b , dr_1_accompany as c ";
$sql.=" where b.zsoff='是' and b.sfph='1' and a.uid<>'1' and b.uid=a.uid and c.uid=a.uid";
$sql.=" and b.sex='$sex' and (b.service like '%".$values."%') ";
以下是三张表的结构:
试试 select distinct * ?
去重肯定是根据某个条件的,比如uid
不考虑效率,可以使用distinct(uid)或者group by uid
可以在包个子查询去重