字符串匹配(近似查找法) 用like来查找 1 2 3 4 select order_num, order_date from Orders where order_date like '2020-01%' order by order_date 切割字符串 1 2 3 4 select order_num, order_date from Orders where left(order_date, 7) = '2020-01' ...