Convert json to javascript variable

Question

I'm new to node and javascript. Sorry if this is an obvious question.

I retrieve data from mysql using the node,js code below:

     var quer = connection.query('select password from users where  mail="'+ so +'" ',function(err, result, fields){

               console.log(result);

        });

Result is this

    [{password:'123456'}]

I want to get it as only 123456, how can I achieve that?

result is an array that contains an object with a password, it's not JSON. So console.log(result[0].password) should do it. — Matt Greer
– Matt Greer, Commented Feb 16, 2014 at 17:27

Jaroslav · Accepted Answer · 2014-02-16 18:20:04Z

2

It's easy:

console.log(result[0].password)

answered Feb 16, 2014 at 18:20

Jaroslav

2,3531 gold badge14 silver badges10 bronze badges

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

Collectives™ on Stack Overflow

Convert json to javascript variable

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