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 vote329 views1 answer
Create boolean column in MySQL with false as default value?
SQL
0 vote412 views1 answer
How to rename a database in tsql
SQL
34 votes379 views6 answers
Alter table add foreign key mysql
SQL
1 vote361 views1 answer
Oracle show execution plan
SQL
0 vote382 views1 answer
Selecting specific day in colum sql
SQL
0 vote323 views1 answer
Database xml sql
SQL
-1 vote265 views1 answer
How to create script to connect to oracle database and run query
SQL
0 vote296 views1 answer
Alter precision
SQL
0 vote351 views1 answer
Pgadmin save data greyed out
SQL
2 votes304 views2 answers
Join update query in sql
SQL