MySQL日期比较过滤器

Question

我有一些SQL代码，很好用，并从我的Wordpress数据库返回所需的结果。

但是，我根本不能让我围绕着如何筛选发言权之间的日期头：

2010-12-10 00:00:00 

和

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 "; 

Answer 1

WHERE date_column BETWEEN STR_TO_DATE('2010-12-10', '%Y-%m-%d') AND STR_TO_DATE('2010-12-15', '%Y-%m-%d') 

像这样？

编辑：忘了结束报价。哎呀

EDITv2：将您的代码与更新的查询

EDITv3：小优化 删除1 = 1相比，使用IN（）用于wp_posts.post_status

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 

Answer 2

use between date1 and date2