Accessing MySQL COUNT(*) result object in JavaScript

Question

When I run a query like,

SELECT item, COUNT(*) FROM table WHERE item IN (1,2) GROUP BY item;

I get back an normal array with the objects returned, but I can't access the COUNT(*) value with a normal operation such as

result[0].COUNT(*)

as I would normally do result[0].item

How am I supposed to access this item? I tried to search for it around, but I only found solutions for PHP. Thanks

wizulus · Accepted Answer · 2014-02-28 19:05:23Z

3

Name your aggregate column in your query

SELECT item, COUNT(*) as [count] FROM table WHERE item IN (1,2) GROUP BY item;

and access it as a column

result[0].count

answered Feb 28, 2014 at 19:05

wizulus

6,4312 gold badges26 silver badges41 bronze badges

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

Comments

Leroy · Accepted Answer · 2014-02-28 19:05:10Z

3

Try this SQL:

SELECT item, COUNT(*) AS count FROM table WHERE item IN (1,2) GROUP BY item;

Then in your javascript you can do: result[0].count

answered Feb 28, 2014 at 19:05

Leroy

5543 silver badges14 bronze badges

Jon Taylor · Accepted Answer · 2014-02-28 19:05:24Z

2

If it's a naming issue, then rename the column like this

count(*) as count

then access it as before with result[0].count

answered Feb 28, 2014 at 19:05

Jon Taylor

7,9255 gold badges32 silver badges55 bronze badges