查询的字段包含有%和_全/半模糊查询,会导致不匹配,可以按如下方式处理,有几个模糊查询需要在后面添加几个ESCAPE ‘/’
```go
batchName = util.AddSlash(batchName)
sqliteDb = sqliteDb.Where("batch_name LIKE ? ESCAPE '/'", "%"+batchName+"%")
func AddSlash(str string) string {
return strings.ReplaceAll(strings.ReplaceAll(str, "%", "/%"), "_", "/_")
}