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

5 votes194 views1 answer
How to check nls timestamp format in oracle
SQL
1 vote202 views1 answer
Sql bitwise operators
SQL
0 vote190 views1 answer
Sql constarint
SQL
2 votes193 views1 answer
Can you use a where clause for a child query
SQL
0 vote272 views1 answer
Sql server remove primary key without dropping table
SQL
3 votes222 views2 answers
Mysql import gz
SQL
22 votes337 views4 answers
Mysql date format
SQL
11 votes257 views2 answers
Docker create postgres db
SQL
1 vote202 views1 answer
Stored procedure return value
SQL
0 vote196 views1 answer
Teller stamp , bmo , PDF
SQL