MySQL时间范围查询相关语句

SELECT * from yjs_qy_zl where sqrq like '%2000%' or sqrq like '%2023%'

SELECT * FROM yjs_qy_zl WHERE SQRQ  between '2000-01-01 00:00:00' and '2020-01-01 00:00:00'

SELECT * FROM yjs_qy_zl WHERE SQRQ  between '2000' and '2023'

@GetMapping("/list")
	@ApiOperationSupport(order = 2)
	@ApiOperation(value = "分页", notes = "传入zl")
	public R<IPage<ZlVO>> list(Zl zl, Query query) {
		String sqrqAAA = zl.getSqrq();
		QueryWrapper queryWrapper = new QueryWrapper<>(zl);
		queryWrapper.like(zl.getSqrq() != null,"sqrq",sqrqAAA);
		zl.setSqrq(null);
		System.out.println(zl.getSqrq());
		IPage<Zl> pages = zlService.page(Condition.getPage(query), queryWrapper);
		return R.data(ZlWrapper.build().pageVO(pages));
	}