mysql> SELECT count(*) FROM privatemessage WHERE messageread = '0' AND touserid = '3913'; +----------+ | count(*) | +----------+ | 2 | +----------+ 1 row in set (0.00 sec)