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 votes270 views5 answers
Sqlite install python
SQL
0 vote270 views1 answer
Sql query use select name inside where clause
SQL
5 votes268 views6 answers
Sql foreign key
SQL
2 votes254 views1 answer
Set boolean flasksql
SQL
6 votes310 views2 answers
Oracle undotbs usage
SQL
0 vote256 views1 answer
Mariadb maximum left join
SQL
15 votes276 views4 answers
Create table if not exists sql
SQL
0 vote301 views3 answers
How to find all role in mysql
SQL
0 vote275 views1 answer
Space not removing from column in sql
SQL
2 votes247 views1 answer
Mysql time ago difference
SQL