How to get only the value of a stringified MySQL query result?

user_2230939 0
Viewed 591

After executing this query:

con.query("SELECT name FROM members WHERE id=1", function(err, rows, fields) {
   console.log(rows); 
});

this is what I get:

[ RowDataPacket { name: 'John' } ]

I expect only one record and I only want to get John. How do I do that?

stringify node.js mysql
2 Answers

Short of writing your own additional function(s) and passing the row object through them your desired result format is not possible based on the design of the mysqljs/mysql package. In a standard SELECT query the result is always an object.

There is a bit of a hack workaround by using the stream function. Below is an example, but you will still end up with more lines of code than you would if you simply accessed the value via rows[0].name in a standard query.

let the_query = con.query('SELECT name FROM members WHERE id = 1;');
the_query
.on('result', function(row) {
  console.log('row.name:', row.name);
  // expected in log:
  // row.name: John
})
.on('end', function() {
  // this chained event can be excluded
  // here for demo purposes
  console.log('all done');
});
user_17208730 
JSON.stringify(RowDataPacket[0].name)

This will output:

John

user_81388490
Related