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

15 votes169 views4 answers
Mysql export database command line
SQL
0 vote144 views1 answer
MySQL - Enabling the Event Scheduler
SQL
1 vote163 views2 answers
Oracle 18c xe ORA-65096
SQL
0 vote151 views1 answer
Query for backup a database at another location in file system
SQL
0 vote164 views1 answer
Influxdb list all tags for a measurement
SQL
0 vote135 views1 answer
Sql query interview questions githu
SQL
0 vote151 views1 answer
TSQL function split string
SQL
2 votes139 views2 answers
HOW TO FIND MEDIAN IN SQL FOR BOTH IDD AND EVEN
SQL
0 vote153 views1 answer
VERIFY INDEXES WITH PARTITIONS IN SQL ORACLE
SQL
0 vote147 views2 answers
Temp Space
SQL