Question 21090 in Mysql Question posted in
The official MySQL documentation can be found here.

How to count notifications with a certain status and a certain user_id? – Mysql

enter image description here
How to count notifications with a certain status and a certain user_id ?
I have some data in notification table, how is the logic to calculate notification whose status is field 3 based on user_id 2 ?
I want to issue a total of 3 notifications with a status field of 3 in user_id 2

Tags:

2

Answers


  1. 0

    You are searching for the group by function.

    For all users and statuses:

    SELECT COUNT(user_id), user_id, status FROM {Insert your table name} GROUP BY user_id, status ORDER BY user_id ASC;
    Login or Signup to reply.
  2. 0 
    calculate notification whose status is field 3 based on user_id 2

    According to what you asked, the where condition is status field 3 based on user_id 2.

    So you can do in this way

    SELECT COUNT(*) FROM tablename WHERE status = 3 AND user_id = 2

    Please show us your effort next time. Thank you

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search