选择一个大于当前日期的日期 [英] SELECT a date that is greater than current date

问题描述

我有一个MySQL数据库表，其中一个单元格包含多个日期，并且我想选择包含一个或多个日期大于当前日期的单元格的所有行吗? (使用PHP)

I have a MySQL database table where a single cell contains multiple dates and I am wanting to SELECT all rows that contain a cell where one or more of the dates is greater than todays date is this possible? (using PHP)

推荐答案

确定:

select * from MyTable where MyDate > Now()

您的单个​​字段如何包含多个日期?也许您应该为此考虑一个单独的表.

How does your single field contain multiple dates? Maybe you should consider a separate table for this instead.

这篇关于选择一个大于当前日期的日期的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！