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 vote308 views1 answer
Pagination with row_number
SQL
0 vote280 views1 answer
Sql if clause within where clause
SQL
0 vote258 views1 answer
Sql server cannot create database diagram
SQL
0 vote313 views1 answer
Postgres docs /copy metacomand
SQL
1 vote262 views2 answers
Login to mysql
SQL
0 vote306 views1 answer
Psql create usr
SQL
0 vote260 views1 answer
Mysql count by month
SQL
2 votes259 views1 answer
Oracle drop table free up space
SQL
0 vote254 views1 answer
Delete double on SQL with multiple primary keys
SQL
0 vote264 views1 answer
Oracle to_number
SQL