Display NULL only

[kendris]

I'm trying to display the null values only, where am I going wrong?

SELECT IFNULL(trans, 0) AS 'Transactions', customer.cID AS 'Customer ID', customer.surname AS 'Surname'
FROM customer
LEFT JOIN account
ON (account.cID = customer.cID)
WHERE IFNULL(trans, 0);

[kendris]

I'm an idiot it was...

SELECT IFNULL(trans, 0)  AS 'Transactions', customer.cID AS 'Customer ID'
FROM customer
LEFT JOIN account
ON (account.cID = customer.cID)
WHERE account.trans IS NULL;