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

18 votes117 views4 answers
Uninstall mysql ubuntu 18.04
SQL
8 votes120 views1 answer
Today minus 15 days postgresql
SQL
0 vote149 views1 answer
Sqlalchemy empty table
SQL
6 votes131 views1 answer
How to count number of rows in sql
SQL
1 vote132 views2 answers
Mysql update table from another table
SQL
1 vote118 views2 answers
Sql server backup table
SQL
0 vote148 views1 answer
What is server_default = func.now() in sqlalchemy
SQL
6 votes162 views2 answers
Install psql mac
SQL
1 vote127 views2 answers
Mysql update LAST_INSERT_ID()
SQL
0 vote118 views2 answers
Mysql set foreign_key_checks=0
SQL