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 vote288 views1 answer
Sql show table name in result
SQL
0 vote267 views1 answer
Inser into example
SQL
25 votes290 views5 answers
Date in mysql
SQL
0 vote277 views1 answer
Sql tablo hangi sp de
SQL
0 vote281 views1 answer
Postgresql la fonction dblink_connect(unknown, unknown) n'existe pas
SQL
7 votes282 views1 answer
Sql disable safe mode
SQL
-1 vote275 views1 answer
Sql oracle take only last results
SQL
0 vote287 views2 answers
Mysql calcular idade
SQL
0 vote292 views1 answer
Ansi sql count duplicate rows
SQL
0 vote274 views1 answer
Write a PL/SQL to print even numbers upto 100.
SQL