0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for people interested in conceptual questions about life and challenges in a world where "cognitive" functions can be mimicked in purely digital environment

-- data security related posts

SELECT *,
       CASE
           WHEN Title LIKE '%data security posture%' THEN 'DSPM'
           WHEN Title LIKE '%DSPM%' THEN 'DSPM'
           WHEN Title LIKE '%data classification%' THEN 'data classification' 
           WHEN Title LIKE '%data security%' THEN 'data security'
           WHEN Title LIKE '%data privacy%' THEN 'data privacy'
           ELSE 'other'
       END AS TagCategory
FROM Posts
WHERE CreationDate > '2019-01-01'
AND (
    Title LIKE '%DSPM%' 
    OR Title LIKE '%data security%'
    OR Title LIKE '%data classification%'
    OR Title LIKE '%data security%'
    OR Title LIKE '%data privacy%'
);

fork query

created dec 9 anonymous