MP中的字段还可以利用函数来查询拼接sql

 //根据value查询
    @GetMapping("getTest")
    public List getTest() {
        QueryWrapper queryWrapper = new QueryWrapper<>();
        queryWrapper.eq("substr(name,1,2)","99999");
        List list1 = testService.list(queryWrapper);
        List list = dictService.getTest();
        return list;
    }