This question already has an answer here:
I have a JSON entry like this, which I need to enter into a column (called values)
["Price Descending","Price Ascending","Name Ascending","Date Descending"]
How can I enter this into a json column , what I am trying is this
$this->db->query("
INSERT INTO tag_sets (type, value) VALUES
('sorting_options', "
'Price Descending', 'Price Ascending', 'Name Ascending',
'Date Descending'";
");
This gives me an error, what is the correct way to insert into a json column?
</div>