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 vote137 views1 answer
Alter table add column in SQL Server- NAYCode.com
SQL
0 vote149 views1 answer
Kill thread
SQL
0 vote155 views1 answer
How to select even id in sql
SQL
1 vote157 views1 answer
Mysql column start with string
SQL
3 votes94 views2 answers
Mysql sum with condition
SQL
5 votes163 views3 answers
String concatenation sql server
SQL
0 vote144 views1 answer
Sauvegarde complète my sql
SQL
0 vote158 views2 answers
Nodejs mysql convert to plain object
SQL
3 votes137 views1 answer
Postgresql if null then 0
SQL
0 vote153 views1 answer
Django mysqlclient connection string
SQL