mysql count different fields depending on fields value

Question

I have a table which looks like this:

from_user    to_user      type
    43          85          1
    32          43          2
    64          79          1
    77          43          4
    54          43          5
    13          96          4
    78          43          6

I have a variable $user, and I need a query which returns the sum of from_user (i.e. how many from_users are there) where it equals $user, but only if type=1. If type=4 or 5, I need the sum of to_user where it equals $user. Is it possible to do this in one query?

Thanks in advance!

And what about the other types like 2, 3, or those after 6?

Jerry
– Jerry

2013-04-07 15:38:12 +00:00
Commented Apr 7, 2013 at 15:38 — Jerry
– Jerry, Commented Apr 7, 2013 at 15:38
is type also an input variable?

jurgenreza
– jurgenreza

2013-04-07 15:50:59 +00:00
Commented Apr 7, 2013 at 15:50 — jurgenreza
– jurgenreza, Commented Apr 7, 2013 at 15:50

John Woo · Accepted Answer · 2013-04-07 15:43:53Z

2

SELECT  SUM(Type = 1 AND From_User = 'user_ID_HERE') From_User,
        SUM(Type IN (4,5) AND to_user = 'user_ID_HERE') To_User
FROM    TableName

SQLFiddle Demo

edited Apr 7, 2013 at 15:43

answered Apr 7, 2013 at 15:38

John Woo

265k70 gold badges509 silver badges500 bronze badges

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

Collectives™ on Stack Overflow

mysql count different fields depending on fields value

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related