select * from table t
where case when nameParam is not null then ',' || nameParam || ',' else ',' || t.name1|| ',' end like '%' || t.name1|| '%'
order by iddesc
我对where后面这一堆逗号还有case if 的,给搞的不清楚,||表示什么意思?
谁能帮我解释一下,where后面的意思
where case when nameParam is not null then ',' || nameParam || ',' else ',' || t.name1|| ',' end like '%' || t.name1|| '%'
order by iddesc
我对where后面这一堆逗号还有case if 的,给搞的不清楚,||表示什么意思?
谁能帮我解释一下,where后面的意思
',' || nameParam || ','
else
',' || t.name1|| ','
end
like '%' || t.name1|| '%'
那么 ',' || nameParam || ',' = ',abc,'
nameParam is null 的时候取t.name1