如果两列与mysql不匹配，则删除一行

flseospp 于 2021-06-20 发布在 Mysql

关注(0)|答案(2)|浏览(268)

SELECT follower_id, poster_id, recipient_id
FROM followers
INNER JOIN post on followed_id = poster_id
WHERE follower_id = 1;

returns:

+-------------+-----------+--------------+
| follower_id | poster_id | recipient_id |
+-------------+-----------+--------------+
|           1 |         2 |            2 |
|           1 |         2 |            2 |
|           1 |         2 |            2 |
|           1 |         2 |            7 |
+-------------+-----------+--------------+

有没有办法省略poster\u id！=收件人id？我需要前三排。。。

mysql

来源：https://stackoverflow.com/questions/51974739/removing-a-row-if-two-columns-dont-match-with-mysql

2条答案

按热度按时间

eimct9ow1#

SELECT follower_id, poster_id, recipient_id
FROM followers
INNER JOIN post on followed_id = poster_id
WHERE follower_id = 1 AND poster_id != recipient_id;
LIMIT 3;

赞(0）回复(0）举报 2021-06-20

whlutmcx2#

如果只需要在结果中省略它们，请使用 AND 操作员输入 WHERE 条款。

SELECT follower_id, poster_id, recipient_id
FROM followers
INNER JOIN post on followed_id = poster_id
WHERE follower_id = 1 AND poster_id != recipient_id;

赞(0）回复(0）举报 2021-06-20

我来回答

如果两列与mysql不匹配，则删除一行

2条答案

相关问题

热门标签

最新问答