imei 尾号 14 筛选语句
方法1:
imei rlike "14$"
方法2:
imei like "%14"
日期选择的几种方式:
day in ("2022-06-09", "2022-06-10")
day = "2022-06-09"
day >= "2022-06-09" and day <= "2022-06-20"
查询可以做嵌套
imei 尾号 14 筛选语句
方法1:
imei rlike "14$"
方法2:
imei like "%14"
日期选择的几种方式:
day in ("2022-06-09", "2022-06-10")
day = "2022-06-09"
day >= "2022-06-09" and day <= "2022-06-20"
查询可以做嵌套