How to convert this mysql select return into one array

Question

Is there anyway to convert this like the example below?

Convert this:

[
  RowDataPacket { title: 'Code' },
  RowDataPacket { title: 'Pizza' }
]

Into this:

['Code', 'Pizza']

by using Array#map: yourArray.map(rdp => rdp.title). Check this out: stackoverflow.com/a/31229034/6567275 — Thomas
– Thomas, Commented Mar 28, 2017 at 13:47

kind user · Accepted Answer · 2017-03-28 13:49:05Z

4

I've provided you two possible solutions, in case if it's just an array of objects or an array of nested objects.

var arr = [{RowDataPacket: { title: 'Code' }}, {RowDataPacket: { title: 'Pizza' }}],
    res = arr.map(v => v.RowDataPacket.title);
    console.log(res);

var arr = [{ title: 'Code' }, { title: 'Pizza' }],
    res = arr.map(v => v.title);
    console.log(res);

answered Mar 28, 2017 at 13:49

kind user

42k8 gold badges69 silver badges78 bronze badges

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

Comments

Reinard Truter · Accepted Answer · 2017-03-28 13:51:15Z

-1

Create a new array

var newArr = [];

And then push each item into the array

result.forEach(function(obj){
   newArr.push(obj.title);
}

edited Mar 28, 2017 at 13:51

answered Mar 28, 2017 at 13:48

Reinard Truter

695 bronze badges

1 Comment

Atheist Over a year ago

foreach should be forEach() - but I can't make such a short edit :)

Collectives™ on Stack Overflow

How to convert this mysql select return into one array

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related