SQL COUNT() WHERE multiple values

Question

I'll make this post short: I want to count the number of times my row appears in my table where the row is a specific value And another row could be 4 different values. I'll post my "guess" which doesn't work:

SELECT hero_selected, COUNT(hero_type) FROM heroes WHERE hero_type = 'agi' AND hero_selected = 'yt' OR hero_selected = 'yb' OR hero_selected = 'ym' OR hero_selected = 'yf

INFORMATION ABOUT THE TABLE

TABLE NAME
heroes

ROW TO COUNT
hero_type

SELECT "hero_type" WHERE
Value is 'agi'

ONLY SELECT IT WHERE "hero_selected" IS
Either yt, yb, ym or yf

If possible I'd also appreciate the full code including an echo of the count amount in php. Thanks A LOT in advance! :)

Is the missing ' at the end a mis-copy? Also, what results do you get opposed to what you expect? — Lee Louviere
– Lee Louviere, Commented Aug 10, 2011 at 0:06

Joel Coehoorn · Accepted Answer · 2011-08-10 01:44:27Z

5

SELECT COUNT(*) 
FROM heroes 
WHERE hero_type = 'agi' AND hero_selected IN ('yt', 'yb', 'ym', 'yf')

edited Aug 10, 2011 at 1:44

answered Aug 10, 2011 at 0:07

Joel Coehoorn

418k114 gold badges582 silver badges820 bronze badges

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

1 Comment

Cheezen Over a year ago

Thanks a lot for the fast answer! But it's not the complete solution to my problem though. I wanted (maybe hard to get from my explanation) only one number.

Phil · Accepted Answer · 2011-08-10 00:09:39Z

0

From what I can glean from your question, you want this query

SELECT COUNT(1) FROM heroes
WHERE hero_type = 'agi'
AND hero_selected IN ('yt', 'yb', 'ym', 'yf')

PHP code might look like this

$db = new PDO(...);
$stmt = $db->query($query);
$count = $stmt->fetchColumn();
echo $count;

I'm assuming here that you only want a single count, not one per different hero_selected value as the other answers are indicating

answered Aug 10, 2011 at 0:09

Phil

166k25 gold badges265 silver badges269 bronze badges

3 Comments

Phil Over a year ago

@Xaade Come again? The question asks for "including an echo of the count amount in php"

Cheezen Over a year ago

Thanks for the fast answer! Worked perfectly, appreciate the help! By the way, just one question: do you guys get anything from helping people here? By that I mean if you can buy stuff for the reputation points or what it's called. If you don't... then you guys are insanely kind!

Phil Over a year ago

@Cheezen We get that warm, glowing, warming glow. Also, see stackoverflow.com/faq#reputation

Collectives™ on Stack Overflow

SQL COUNT() WHERE multiple values

INFORMATION ABOUT THE TABLE

2 Answers 2

1 Comment

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

INFORMATION ABOUT THE TABLE

2 Answers 2

1 Comment

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related