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

3 votes209 views1 answer
Start mysql server by terminal in linux
SQL
0 vote232 views1 answer
Modifier une valeur sql
SQL
4 votes199 views1 answer
Id increment ms sql server
SQL
-1 vote184 views1 answer
MYSQL stored procedure select from
SQL
0 vote171 views1 answer
Sort by last two number sql
SQL
0 vote181 views1 answer
How to get inserted id in sql server
SQL
0 vote150 views1 answer
Sqlalchemy filter relationship
SQL
7 votes199 views2 answers
Mysql default value
SQL
-1 vote206 views4 answers
Postgres between dates
SQL
0 vote211 views1 answer
One table with another
SQL