java - 如何解决where name like '%%' 当name 为null时，查询不到数据?

Answer 1

Why can’t we judge the two query variables before executing the SQL statement?

The pseudo code is as follows:

if (isNull(a)) {
    a = '';
}

if (isNull(b)) {
    b = '';
}

Answer 2

From the perspective of efficiency, it is strongly recommended that when name or method is empty, the value will not be used as a query condition
For example, if name is empty, it is directly
where method like '%xxx%'