我在MySQL中有以下存储过程
SELECT *
FROM rewards
LEFT JOIN tasks
ON tasks.id = rewards.task_id
AND rewards.received_at = received_Date
WHERE tasks.kid_id = kid_Id
ORDER BY tasks.id ASC;存储过程有2 (IN)输入、kid_Id (整数)和received_Date (日期),并且工作正常。
问题:我想要的是,如果received_Date是NULL,那么我想查看所有的日期,这可能吗?
换句话说,说:
只有当我传递received_Date时,AND rewards.received_at = received_Date才能工作,否则返回所有日期。
发布于 2014-11-19 21:42:57
尝尝这个。使用OR操作符在where clause中获取所有行(如果是received_Date is null )
SELECT *
FROM rewards
LEFT JOIN tasks
ON tasks.id = rewards.task_id
WHERE tasks.kid_id = kid_Id
AND (rewards.received_at = received_Date or received_Date = 0)
ORDER BY tasks.id ASC;https://stackoverflow.com/questions/27027478
复制相似问题