我有一些运行良好的 SQL 代码,并从我的 Wordpress 数据库返回所需的结果。
但是,我根本无法理解如何过滤以下日期之间的日期:
2010-12-10 00:00:00
and
2010-12-15 00:00:00
这是我的 SQL 代码:
$SQL_K = "SELECT SQL_CALC_FOUND_ROWS wp_posts.*
FROM wp_posts
JOIN wp_postmeta ON (wp_posts.ID = wp_postmeta.post_id)
WHERE 1 = 1
AND wp_posts.post_type = 'post'
AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'private')
AND wp_postmeta.meta_key = 'expiry_date'
GROUP BY wp_posts.ID
ORDER BY wp_posts.post_date DESC
LIMIT 0, 100 ";
WHERE date_column BETWEEN STR_TO_DATE('2010-12-10', '%Y-%m-%d') AND STR_TO_DATE('2010-12-15', '%Y-%m-%d')
Like so?
编辑:忘记了结束语。哎呀
EDITv2:使用更新的查询添加代码
EDITv3:很少优化删除了 1=1 比较,对 wp_posts.post_status 使用 IN()
SELECT SQL_CALC_FOUND_ROWS wp_posts.*
FROM wp_posts
JOIN wp_postmeta
ON (wp_posts.ID = wp_postmeta.post_id)
WHERE wp_posts.post_type = 'post'
AND (wp_posts.post_status IN ('publish','private'))
AND wp_postmeta.meta_key = 'expiry_date'
AND ___INSERT_NAME_OF_DATE_COLUMN_HERE___
BETWEEN STR_TO_DATE('2010-12-05', '%Y-%m-%d')
AND STR_TO_DATE('2010-12-15', '%Y-%m-%d')
GROUP BY wp_posts.ID
ORDER BY wp_posts.post_date DESC
LIMIT 0, 100
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)