SQL Query Question

[Ian Barnes]

Hi,

Im making a query and im stuck with something at the moment. Here is a sample of my query

select domain, count(id) as count, sum(bytes) as bytes, if(isspam,sum(bytes),0) as spams from data;

now the result would be as follows:

---------------------------------------------------
| Domain | Count | Bytes | Spams |
---------------------------------------------------
mysql.com 560 7788662 7788662

Whereas it should output

---------------------------------------------------
| Domain | Count | Bytes | Spams |
---------------------------------------------------
mysql.com 560 7788662 123789

I dont know if that makes sense, ill try and explain more:

The if(isspam) statement is ment to increase the size of spams if the current entry has a "1" in the isspam field. What happens now is that if it matches once, it totals everything and hense the two sizes are the same.

Is there any way that I can achieve this? I want to have an over total (Bytes) and then a Spam total (Spams), the Spams must be lower as not all entries are spam, only some of them.

Regards,
Ian