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 vote259 views3 answers
Insert or ignore postgres
SQL
2 votes144 views2 answers
How to check database username and password in postgresql
SQL
0 vote160 views1 answer
Consecutive numbers sql
SQL
2 votes150 views1 answer
How to search table name in stored procedure in sql server
SQL
0 vote148 views1 answer
Double in sql server example
SQL
1 vote147 views1 answer
How to install mysql 8.0 windows service
SQL
5 votes172 views2 answers
Mysql where in array
SQL
0 vote146 views1 answer
What is the difference between now() and current_date()?
SQL
-2 votes151 views1 answer
Use of where in left join in mysql
SQL
4 votes151 views1 answer
Oracle error compilation line
SQL