Mysql get things after certain date
So, I have a database table holding tickets. One of the fields is "availableUntil".
when I make the database call to get tickets, I want to be able to exclude those tickets who's date has already been passed relative to the current dat开发者_StackOverflow社区e.
Anyone know of a way to do this?
SELECT blablabla... WHERE availableUntil >= CURRENT_TIMESTAMP
SELECT [what_you_want] FROM your_base WHERE availableUntil > CURRENT_DATE();
精彩评论