Filter results by todays date - MySQL

Published: 13 years ago

MySQL is a very powerful open source database and there was no suprise when I found there was a way to retrieve records from a database that expired at @ 11.59 of the "end_date" field. You can alternatively do this via php date() function as well.

The Solution

All I wanted to happen was a simple way to display meetings that weren't expired, so therefore including any meetings up till 11.59pm.

The Query

SELECT id, title FROM meetings WHERE start_date < NOW() AND end_date > DATE(NOW()) ORDER BY id DESC

comments powered by Disqus
:?>