dongyan5706 2017-05-15 08:31
浏览 5
已采纳

MySQL:仅选择X未包含在另一个表中的行

I'm having a little trouble getting this to work exactly how I want it to work. I have a table called users and then I have a table called friendships.

Every time someone sends a friend request and it gets accepted, the friendship is added to a log that contains requester,accepter.

Now I have a page where all users are located and you can friend them. How would I go about not showing people on this page that are already friended by me (through looking at the friendships table/logs).

  • 写回答

1条回答 默认 最新

  • douzhi3776 2017-05-15 09:09
    关注

    Managed to fix it by using NOT IN together with an array containing all the friendship IDs.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥100 连续两帧图像高速减法
  • ¥15 组策略中的计算机配置策略无法下发
  • ¥15 如何绘制动力学系统的相图
  • ¥15 对接wps接口实现获取元数据
  • ¥20 给自己本科IT专业毕业的妹m找个实习工作
  • ¥15 用友U8:向一个无法连接的网络尝试了一个套接字操作,如何解决?
  • ¥30 我的代码按理说完成了模型的搭建、训练、验证测试等工作(标签-网络|关键词-变化检测)
  • ¥50 mac mini外接显示器 画质字体模糊
  • ¥15 TLS1.2协议通信解密
  • ¥40 图书信息管理系统程序编写