mysql group by统计不为空,在MySQL中计算和分组非空值

I need to count the non-empty (by which I mean a string containing at least 1 character) rows grouped by a particular ID. Eg. my data might look like this:

form_id mapping

1 'value_1'

1 ''

1 'value_2'

2 ''

2 NULL

3 'value_3'

and I want to count the non-empty values for each form, so I want the results to look like this:

form_id mapping_count

1 2

2 0

3 1

If the empty values were all NULL, I guess I could use

SELECT form_id, count(mapping) FROM table GROUP BY form_id

...but that would include zero-length strings in the count, which I don't want.

I could use a where clause to only return rows where a value exists in the mapping column, but I want to return the form IDs that have no mappings, so that is no good either.