mysql - 连接多个表时值重复

Question

我正在尝试从多个表中获取数据，其中包含不同表中用户的各种详细信息。问题是，在加入时它显示重复的值

ID  NAME    DOB GENDER  CITY    RELATIONSHIP_STATUS ABOUT_ME    PROFILE_PIC_PATH    EMPLOYEER   JOB EMP_START   EMP_END EMP_VISIBILITY  SCHOOL  MAJOR   EDU_START   EDU_END EDU_VISIBILITY  IM_ON_SITE  IM_IM   IM_VISIBILITY   ADDRESS STATE   CONTRY  ZIP ADDRESS_VISIBILITY  ADDRESS_TYPE
1   ABC DEF August, 08 2011 00:00:00+0000   m   Durg    Single  hiii    /usr/img/p1.jpg google,google,google,google,google,google,google,google,google,google,google,google,yahoo,yahoo,yahoo,yahoo,yahoo,yahoo,yahoo,yahoo,yahoo,yahoo,yahoo,yahoo,facebook,facebook,facebook,facebook,facebook,facebook,facebook,facebook,facebook,facebook,facebook,facebook

我的在线查询链接是here

Answer 1

在 GROUP_CONCAT() 函数中，您只需添加 DISTINCT 即可删除重复项。

喜欢

GROUP_CONCAT(DISTINCT column_name)