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

3 votes126 views2 answers
See mysql users ubuntu
SQL
10 votes117 views1 answer
Oracle dba_dependencies
SQL
4 votes107 views2 answers
Linq join
SQL
0 vote109 views1 answer
Mysql multiple count
SQL
3 votes112 views1 answer
Two selects in one query
SQL
17 votes117 views3 answers
Cast in sql server
SQL
0 vote120 views1 answer
Use mysql in java program
SQL
3 votes119 views2 answers
Mysql HAVING
SQL
2 votes161 views1 answer
Remove foreign key constraints in postgres
SQL
0 vote116 views2 answers
Check mysql timezone
SQL