Question

Sql文的where中使用case when时,能不能用like 若能,请用简单的代码演示一下 谢谢！

Answer 1

Select
type = case when column1 like '%_abc_%' then 'a'
when column2 like '%GGG%' then 'b'
when column1 like '%_def_%' then 'c'
else 'others' end,
column1,
column2
from table1
where 1=1