MySQL Group by except nulls or blanks?

yepwingtim

Registered User.
Local time
Today, 09:17
Joined
Jun 6, 2008
Messages
126
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!
 

Users who are viewing this thread

Back
Top Bottom