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 vote158 views1 answer
Como hacer un select entre fechas mysql
SQL
4 votes127 views3 answers
Order by value mysql
SQL
2 votes141 views1 answer
Oracle to_char number format percentage
SQL
3 votes159 views1 answer
What is having
SQL
3 votes131 views1 answer
Select nextval from sequence sql
SQL
0 vote157 views1 answer
Login failed for user sql server
SQL
0 vote122 views1 answer
Change default schema sql server
SQL
1 vote132 views1 answer
Oracle apex prevent initial load
SQL
0 vote167 views1 answer
Dynamic where clause in sql server stored procedure
SQL
1 vote130 views1 answer
ELECT list is not in GROUP BY clause and contains nonaggregated column 'schogdsw_db.SE.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL