Select specific element from set of MYSQL elements in node js

Question

I have a Request table that has some columns. I need to select a row in the table and then use a specific column value(say request_initiator) to search it in another table.

connection.query('SELECT * FROM Requests WHERE `request_id` = ?', req.body.id, function(error,results, fields){}

My results gives me multiple objects which then contains the component elements with different value.

0   
request_id  1
user_id "user1"
from    "[email protected]"
to  "owner2"
status  "deleted"
1   
request_id  2
user_id "user4"
from    "[email protected]"
to  "owner2"
status  "pending"

I have to access results to get from and then search it in Owners table.

However, results.from doesn't give anything. results[0] gives the first object but I can't access the elements of that list

How should I proceed with this?

{"Request_id":1,"user_id":"user1","from":"[email protected]","to":"owner2","status":"deleted"} — therealshankman
– therealshankman, Commented Jun 12, 2019 at 8:33
I don't get it. Then results[0].from should've worked. May be console.log(results[0]["from"]) — TheMaster
– TheMaster, Commented Jun 12, 2019 at 8:39

TheMaster · Accepted Answer · 2019-06-12 08:47:13Z

2

results is a array of multiple objects. You can access the from key's value using

results[0]["from"]

answered Jun 12, 2019 at 8:47

TheMaster

51.6k7 gold badges76 silver badges102 bronze badges

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

Collectives™ on Stack Overflow

Select specific element from set of MYSQL elements in node js

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