SELECT IF(priority_date, priority_date, created_at) as created_at
FROM table
WHERE IF(priority_date , priority_date , created_at)
BETWEEN '2017-10-10 00:00:00' AND '2017-10-10 23:59:59';
SELECT IF(priority_date, priority_date, created
阅读背景：
优先级/级联日期没有全表扫描。
来源：互联网
分享到：
