[SQL] SELECT 中使用LIKE

[sql]
SELECT
CASE
WHEN col_a LIKE ‘%a%’ THEN ‘A’
WHEN col_a LIKE ‘%b%’ THEN ‘B’
ELSE ” END
AS ‘EVENT_TYPE’
FROM table
[/sql]