How to convert mySQL JSON column into javascript array?

Question

DB JSON column data: ["admin", "leader", "manager"]
javascript recieves: ["admin", "leader", "manager"]

What is the simplest way to create Javascript array?

Could you add an example of how you are retreiving the data from the database ? — Nicolas
– Nicolas, Commented Jan 8, 2020 at 15:10
@Nicolas It is Datatable render function: targets: ['roles'], render: function (data, type, row) { datatables.net/reference/option/columns.render — mvn.2047
– mvn.2047, Commented Jan 8, 2020 at 15:12

Dmitry Reutov · Accepted Answer · 2020-01-08 15:32:29Z

2

Just replace "&quot ;" to quotes and parse

const s = "[&quot;admin&quot;, &quot;leader&quot;, &quot;manager&quot;]"
const obj = JSON.parse(s.replace(/&quot;/g, "\"")))

but better check why do you receive data in such format

answered Jan 8, 2020 at 15:14

Dmitry Reutov

3,0321 gold badge9 silver badges22 bronze badges

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

2 Comments

It works! Thank you! Appreciate your support! Wish you good year and a lot of profitable projects!

Hahaha, happiness is enough, i dont run for profit.