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

7 votes164 views1 answer
Grant schema permissions postgres
SQL
0 vote171 views2 answers
Wordpress change url in database
SQL
0 vote179 views1 answer
User, group, or role 'open' already exists in the current database.
SQL
11 votes177 views2 answers
How to import mysql database command line
SQL
0 vote163 views1 answer
IS THEre any difference between using default and := in plsql
SQL
0 vote214 views1 answer
Capabilities of sql select statements
SQL
0 vote185 views2 answers
Mysql decimal remove trailing zeros
SQL
0 vote171 views3 answers
Above average salary in sql
SQL
0 vote186 views1 answer
Const pool = mysql.createpool()
SQL
0 vote179 views1 answer
Select from column mysql
SQL