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?

Answer 1

Just replace "&quot ;" to quotes and parse

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

but better check why do you receive data in such format