SELECT * FROM scores s where s.adress like '%北%' and
s.name like '%张%' and s.score='85' and s.stuid='55669' and
s.starttime < ('2019-05-21 22:35:32') and s.starttime >('2014-06-12 22:37:14')
or s.endtime < ('2019-05-21 22:35:32') and s.endtime > ('2014-06-12 22:37:14')
查询时间以及模糊查询
最新推荐文章于 2024-05-07 15:00:00 发布