mysql - 如何在此查询中使用MySql应用带有WHERE CLAUSE的IF条件

这是我的mysql查询，我在这个查询中有一个星期的问题。我不知道如何应用带有WHERE条款的if条件。
查询：

SELECT
*,
IFNULL((SELECT ur.user_rating FROM user_rating ur
WHERE ur.vid_id = v.id AND ur.user_id = '1000'),'NULL') AS user_rating
FROM videos v
WHERE WEEK(v.video_released_date) = WEEK(NOW())
AND
v.`is_done` = 1
ORDER BY v.admin_listing ASC;

我想要或者（我如何用where条款应用这个条件？）

IF( WEEK(v.video_released_date) = WEEK(NOW()) , WEEK(NOW()) , WEEK(NOW())-1)
=
IF( WEEK(v.video_released_date) = WEEK(NOW()) , WEEK(NOW()) , WEEK(NOW())-1)

简报
如果视频发布日期已过且与本周不匹配，则应用上一周
我自己
当我被这样审判的时候他们会把所有的数据都还给我

SELECT
*,
IFNULL((SELECT ur.user_rating FROM user_rating ur
WHERE ur.vid_id = v.id AND ur.user_id = '1000'),'NULL') AS user_rating
FROM videos v
WHERE IF(WEEK(v.video_released_date) = WEEK(NOW()),WEEK(NOW()),WEEK(NOW())-1)
= IF(WEEK(v.video_released_date) = WEEK(NOW()),WEEK(NOW()),WEEK(NOW())-1)
AND
v.`is_done` = 1
ORDER BY v.admin_listing ASC;

我在这个问题上做错了什么？

最佳答案

试试这个-

    SELECT *,
           IFNULL((SELECT ur.user_rating FROM user_rating ur
                   WHERE ur.vid_id = v.id AND ur.user_id = '1000'),'NULL') AS user_rating
    FROM videos v
    WHERE WEEK(v.video_released_date) = IF(WEEK(v.video_released_date) = WEEK(NOW()),WEEK(NOW()),WEEK(NOW())-1)
    AND  v.is_done = 1
    ORDER BY v.admin_listing ASC;