mysql >now()
I have a Calendar of Events table and I would like to select events with dates equal to or greater than today. When I use the following SELECT statement, it only retrieves events in the future (> NOW()):
$db->query("SELECT * FROM events WHERE event_date >= NOW()");
?>
How would I go about selecting all events that are either today or in the future?
Thank you
解决方案
You are looking for CURDATE():
$db->query("SELECT * FROM events WHERE event_date >= CURDATE()");
Or:
$db->query("SELECT * FROM events WHERE event_date >= CURRENT_DATE()");
相关知识
谷歌云搭建wordpress centos7 + apache + mysql + php + wordpress
MySQL学习笔记
NOW Foods 免疫支撑
mysql prestatement
宠物商城+ssm框架+jsp页面+mysql数据库
首家拥有人类级食材的顶级宠物粮“NOW FRESH”和“GO!”入驻京东超市
基于MySQL的宠物商店案例资源
计算机毕业设计java+ssm宠物论坛信息网站(源码+系统+mysql数据库+Lw文档）
Mysql第8章DAO模式上机练习
基于javaweb+jsp的宠物领养信息管理系统(JavaWeb MySQL JSP Bootstrap Servlet SSM SpringBoot)
网址: mysql >now() https://m.mcbbbk.com/newsview237840.html
| 上一篇: 卡巴拉岛SERVER=====【 |
下一篇: 论字符串常量和字符数组 |
