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 vote323 views1 answer
C# datetime to sql server datetime
SQL
0 vote317 views1 answer
T sql return on letters only
SQL
4 votes391 views4 answers
Check constraint in ms sql
SQL
10 votes331 views2 answers
Show tables in schema oracle
SQL
1 vote321 views1 answer
Delete row mssql
SQL
13 votes306 views5 answers
Oracle list tables
SQL
0 vote312 views1 answer
Not between mysql
SQL
1 vote344 views2 answers
Logical operators in sql
SQL
0 vote369 views1 answer
Sql set data from a select query to a temp table and insert
SQL
3 votes353 views2 answers
@sqlresultsetmapping
SQL