如何使用' LIKE '操作符作为' SQL '中的列

Question

我想使用LIKE运算符作为列，如:

SELECT name, (name LIKE '%flow%') AS bool1
FROM table1
WHERE ...

并得到如下结果:

name                 bool1
--------------     ----------
over flow              1
stack over flow        1
stack over             0

Answer 1

select name, case when name like '%flow%' then 1 else 0 end as bool1 
from table1 
where...