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 vote223 views1 answer
Add column to table with default value plsql
SQL
-1 vote247 views5 answers
Not in sql
SQL
0 vote218 views1 answer
Database springboot
SQL
0 vote255 views1 answer
Error code 1241 mysql
SQL
0 vote253 views1 answer
ORA-13717
SQL
16 votes245 views3 answers
MySQL 8.0 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote236 views1 answer
Sql recherche nom prenom
SQL
18 votes216 views6 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
SQL
2 votes252 views1 answer
Oracle generated column
SQL
3 votes244 views1 answer
Two select sql
SQL