|
very easy SQL question
I need a simply SQL query to get the amount of 'Approved' galleries I have in database, and the amount of 'Pending' galleries I have in database
what do I use?
it should be something like this:
SELECT * count(status='Approved') approved, count(status='Pending') pending
FROM galleries
what do you say?
|