MYSQL help, how to count the results

Question

Running this sql:

SELECT
    user_id,
    base_item
FROM
    items
WHERE
    base_item = "202"

gives me this http://prntscr.com/9gwwxq However, how do i expand the MYSQL query to add up the amount of 202 base_items a user_id has. e.g user_id 41 has 6.

No of item count against user?

devpro
– devpro

2015-12-21 19:19:41 +00:00
Commented Dec 21, 2015 at 19:19 — devpro
– devpro, Commented Dec 21, 2015 at 19:19

Chriki · Accepted Answer · 2015-12-21 19:17:58Z

1

This should give you the number of “202” base_items per user ID:

SELECT
    user_id,
    COUNT(*)
FROM
    items
WHERE
    base_item = "202"
GROUP BY user_id

answered Dec 21, 2015 at 19:17

Chriki

16.6k4 gold badges61 silver badges72 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Mahdi Aslami Khavari · Accepted Answer · 2015-12-21 19:18:13Z

0

try it:

SELECT
    user_id,
    count(base_item) as c
FROM
    items
WHERE
    base_item = "202"
group by
    user_id

answered Dec 21, 2015 at 19:18

Mahdi Aslami Khavari

1,99119 silver badges27 bronze badges

1 Comment

Barmar Over a year ago

No need to put base_item in the count function, just use count(*).

A l w a y s S u n n y · Accepted Answer · 2015-12-21 19:20:36Z

0

Try this to count of similar base_item

SELECT
    user_id, 
    base_item, count(*) as user_no
FROM
    items
WHERE
    base_item = "202" 
GROUP BY user_id

edited Dec 21, 2015 at 19:20

answered Dec 21, 2015 at 19:17

A l w a y s S u n n y

38.8k9 gold badges68 silver badges120 bronze badges

1 Comment

omarisgod Over a year ago

gives me this result prntscr.com/9gx0jp . I want the results to be like user_id 2 has 10 or the number they actually have.

Collectives™ on Stack Overflow

MYSQL help, how to count the results

3 Answers 3

Comments

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related