将日期字段的非空检查添加到查询中

Question

有没有办法修改这个查询，让它检查frp_fundraisingprogram.start_date是否不为空或包含缺省值？

SELECT frp_fundraisingprogram.id AS id 
FROM frp_fundraisingprogram  
WHERE frp_fundraisingprogram.start_date <= DATE_ADD(UTC_TIMESTAMP(), INTERVAL - 2 day) 
  AND frp_fundraisingprogram.date_entered > '2015-04-09 16:55:18' 
  AND NOT EXISTS 
    (SELECT * FROM aow_processed 
      WHERE aow_processed.aow_workflow_id='9bc1bb2e-cd5a-5c75-cc68-5526ae30331e' 
      AND aow_processed.parent_id=frp_fundraisingprogram.id 
      AND aow_processed.status = 'Complete' AND aow_processed.deleted = 0) 
  AND frp_fundraisingprogram.deleted = 0 

Answer 1

只需将其包含在where子句中即可。

`...WHERE not isnull(frp_fundraisingprogram.start_date)
AND frp_fundraisingprogram.start_date != '0000-00-00 ...`

也就是说，如果您试图排除这些记录。如果您只想显示这些记录，则可以颠倒逻辑。