count the number of rows in a table that contain a specific string
is there an easy way to return the number of rows from a query that have a particular value in a column.. Ie. if I have a "status" column and have 10 rows in the table and only 5 are marked "open", how can I return a value of 5