使用我的 SQL 连接 [英] Using My SQL joins

问题描述

我在完成 MySQL JOIN 时遇到问题.我不确定查询最后一部分的语法.

I am having trouble finishing my MySQL JOIN. I am unsure of the syntax for the last part of my query.

我的查询:

$posts_query= "
SELECT *
FROM posts p
JOIN relations r ON p.user_id = r.recipient
WHERE (r.status = 1 OR r.status = 2)
AND (r.sender = '".$user_id."' OR p.user_id = '".$user_id."')


// How do I write this part?
AND skip where r.status = 1 and p.privacy = 2 where p.user_id != $user_id // 

ORDER BY p.post_id DESC;
";

推荐答案

不要使用 'skip'，只需将其设置为不为真，使用 NOT:

Instead of 'skip', just set it so that the value isn't true, using NOT:

SELECT *
FROM posts p
JOIN relations r ON p.user_id = r.recipient
WHERE (r.status = 1 OR r.status = 2)
AND (r.sender = '$user_id' OR p.user_id = '$user_id')
AND NOT (r.status = 1 AND p.privacy = 2 AND p.user_id != '$user_id')
ORDER BY p.post_id DESC;"

这篇关于使用我的 SQL 连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！