SELECT COUNT(*) From Results WHERE user_id = ? AND read = '2' SELECT COUNT(*) From Results WHERE user_id = ? AND read = '3' SELECT COUNT(*) From Results WHERE user_id = ? AND read = '4' #### SELECT read, COUNT(*) From Results WHERE user_id = ? AND read in (2,3,4) GROUP BY read