View Full Version : MySQL Group by except nulls or blanks?


yepwingtim
09-21-2011, 06:29 AM
SELECT * FROM `coupons_coupons` group by `group`

I need blanks or nulls NOT to be distinct from column `group`

is there anyway to make an exception like

SELECT * FROM `coupons_coupons` group by `group` except "" or NULL

Thanks!