查询当天的订单号 SELECT order_code FROM order_info WHERE DATE_FORMAT( pay_time, '%Y-%m-%d' ) = CURDATE() 查询某时间段的订单号 SELECT order_code FROM order_info WHERE create_time BETWEEN #{startTime} AND #{endTime}