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

1 vote146 views1 answer
ORACLE RIGHT TWO DIGITS
SQL
8 votes145 views2 answers
Sqlsrv default port
SQL
0 vote152 views1 answer
Simple plsql program run in oracle sql developer but got the error
SQL
0 vote132 views1 answer
Wordpress database query change url
SQL
0 vote184 views2 answers
SQL BULK INSERT
SQL
2 votes132 views3 answers
Write sql query to find the second highest salary of employee
SQL
-1 vote196 views5 answers
Left join sql
SQL
-1 vote178 views1 answer
Difference berween database and data base management system
SQL
0 vote153 views1 answer
Hashpass
SQL
8 votes175 views4 answers
Convert date to dd/mm/yyyy sql
SQL