MYSQL按日期排序，最大日期 [英] MYSQL sort by date with maximum date

问题描述

我正在使用wordpress，我正在按照包含日期的日期自定义字段排序一些帖子。那么我可以按日期对结果进行排序，但是我只想显示直到今天都有结果。我不想从未来日期的帖子中获得结果。

Well I am working with wordpress and I'm trying to sort some posts by the date custom field that contains a date. Well i can sort the results by date, but I only want to show results that have a date until today. I don't want to get results from a post that has a future date.

这是我使用的代码：

$querystr = "
            SELECT wposts.*
            FROM $wpdb->posts wposts, $wpdb->postmeta wpostmeta
            WHERE wposts.ID = wpostmeta.post_id
            AND wpostmeta.meta_key = 'date'
            AND wposts.post_status = 'publish'
            AND wposts.post_type = games'
            ORDER BY STR_TO_DATE(wpostmeta.meta_value, '%m/%d/%Y') DESC
            ";

        $pageposts = $wpdb->get_results($querystr, OBJECT);

推荐答案

将此添加到where子句：

Add this to where clause:

AND STR_TO_DATE(wpostmeta.meta_value, '%m/%d/%Y') <= DATE(NOW())

这篇关于MYSQL按日期排序，最大日期的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！