Issue
I want to know whether there are any '0's in the issues_status column of the issues table. The issues_status column store values: '0' & '1'. I guess a query find the count of 0's would give me the required result. May i know how to accomplish this.
issues Table
| issues_id | issues_status |
|---|---|
| 1 | 1 |
| 2 | 0 |
Solution
SELECT COUNT(issues_status) FROM issues WHERE issues_status=0
Answered By - Alec
Posts
0 Comments:
Post a Comment
Note: Only a member of this blog may post a comment.