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

-- artificial intelligence related posts

SELECT *,
       CASE
           WHEN Tags LIKE '%machine learning%' THEN 'ML'
           WHEN Tags LIKE '%generative AI%' THEN 'GenAI'
           WHEN Tags LIKE '%ChatGPT%' THEN 'GenAI'
           WHEN Tags LIKE '%Google Gemini%' THEN 'GenAI'
           WHEN Tags LIKE '%Google Bard%' THEN 'GenAI'
           WHEN Tags LIKE '%DALL-E%' THEN 'GenAI'
           WHEN Tags LIKE '%OpenAI%' THEN 'GenAI'
           WHEN Tags LIKE '%neural network%' THEN 'Neural Network'
           WHEN Tags LIKE '%artificial intelligence%' THEN 'AI'
           ELSE 'other'
       END AS TagCategory
FROM Posts
WHERE CreationDate > '2019-01-01'
AND (
    Tags LIKE '%ML%' 
    OR Tags LIKE '%GenAI%'
    OR Tags LIKE '%Neural Network%'
    OR Tags LIKE '%AI%'
);

fork query

created jun 6 anonymous