Mysql select count if contains

SELECT sum( case when `tags_Column` CONTAINS 'tag2' then 1 else 0 end ) as tag2,
       sum( case when `tags_Column` CONTAINS 'tag3' then 1 else 0 end ) as tag3,
       .....
       sum( case when `tags_Column` CONTAINS 'tag256' then 1 else 0 end ) as tag256,
       sum( case when `tags_Column` CONTAINS `tag2` OR 
                      `tags_Column` CONTAINS 'tag3`
            then 0 else 1 end ) as doesnt_contains_tags_2_3
FROM `TableContainsTags`

-1

Source: stackoverflow.com

Similar codes

0 vote153 views1 answer
Create api project in visual studio 2019 and sql server
SQL
-1 vote244 views1 answer
Pl sql drop trigger
SQL
0 vote167 views1 answer
Coalesce for comma separated in sql server
SQL
-1 vote177 views1 answer
Mysql select all columns and specific fields as
SQL
3 votes219 views2 answers
How to View column names of a table in SQL
SQL
1 vote182 views2 answers
Sql drop multiple columns if exists
SQL
1 vote264 views1 answer
Sql server delete top 1000
SQL
0 vote184 views1 answer
Mysql local password denied
SQL
0 vote214 views2 answers
The metadata storage is not up to date, please run the sync-metadata-storage command to fix this issue.
SQL
3 votes173 views4 answers
Mysql decimal
SQL