0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for administrators and users of the CiviCRM Constituent Relationship Management software

SELECT *,
       CASE
           WHEN Tags LIKE '%kubernetes%' THEN 'kubernetes'
           WHEN Tags LIKE '%secrets%' THEN 'secrets'
           ELSE 'other'
       END AS TagCategory
FROM Posts
WHERE CreationDate > '2023-01-01'
AND (
    Tags LIKE '%kubernetes%' 
    AND Tags LIKE '%secrets%'
);

fork query

created may 29 anonymous