--我是发送方 SELECT DISTINCT reciverid AS friendid FROM table1 WHERE senderid = 1 UNION --合并会去重 --我是接收方 SELECT DISTINCT senderid AS friendid FROM table1 WHERE reciverid = 1
SELECT * FROM TB WHERE senderId=1 OR reciverId=1
select * from sql where senderId =1 or reciverId=1
select * from sql where 1 in (senderId,reciverId)
select * from tb1 where senderId=1 or reciverId=1 不过你这个问题有点简单啊
SELECT DISTINCT reciverid AS friendid
FROM table1
WHERE senderid = 1
UNION --合并会去重
--我是接收方
SELECT DISTINCT senderid AS friendid
FROM table1
WHERE reciverid = 1
select * from sql where 1 in (senderId,reciverId)
不过你这个问题有点简单啊