有如下图数据表结构,riqi字段类型是date类型
如果要查询某个日期区间的数据,例如查询2023-07-01到2023-07-10期间的数据,可以这样写SQL语句:
$sql = "SELECT * FROM malog where wx_id ='123' and riqi between '2023-07-01' and '2023-07-10'";
但是如果要查询某天的数据呢,比如要查询2023-07-01这天的数据,这里一定要注意了,必须也要用到between and语句。写法如下:
$sql = "SELECT * FROM malog where wx_id ='123' and riqi between '2023-07-01' and '2023-07-01'";