SELECT
count(distinct tag) as tag_count,
count(distinct (case when entryId > 0 then tag end)) as positive_tag_count
FROM
your_table_name;
SELECT
count(distinct tag) as tag_count,
count(distinct (case when entryId > 0 then tag end)) as positive_tag_count
FROM
your_table_name;
Email to link with email parameter opens outlook in browser starts new email
MySQL: update a field only if condition is met
0 Comments