SELECT id FROM `order` WHERE CONCAT_WS(" ",use_date,left(use_time, 5)) < '2021-06-22 11:12:01' AND CONCAT_WS(" ",use_date,right(use_time, 5)) > '2021-06-22 11:12:01' AND status = '1'
CONCAT_WS 拼接字段
left(截取自段)right
公众号技术谈论
SELECT id FROM `order` WHERE CONCAT_WS(" ",use_date,left(use_time, 5)) < '2021-06-22 11:12:01' AND CONCAT_WS(" ",use_date,right(use_time, 5)) > '2021-06-22 11:12:01' AND status = '1'
CONCAT_WS 拼接字段
left(截取自段)right
公众号技术谈论