KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I'm trying to create MySQL query that essentially returns true or false. I'd like to run SELECT COUNT(id) FROM comments WHERE comment_date >= 1306904400 AND user_id = 1 So if the user posted in the forum 10 times this month, I'd like it to return just 1, otherwise I'd like it to return 0 to indicate they haven't. Is that possible efficiently within SQL?
Tags (comma-separated)
Save Edits
Cancel