Warm tip: This article is reproduced from serverfault.com, please click
MySQL query from JSON datatype column that has backslash character
发布于 2020-11-28 01:28:37
I have a difficulty to query element in JSON column in MySQL
This is my data :
example of whats in the column :
{\order\":[{\"product_id\":3,\"quantity\":5,\"product_name\":\"Ikan salmon bakar \"}]}"
I'm using this sql syntax :
SELECT JSON_EXTRACT(order_list, '$.order[*].product_id') FROM orders_copy WHERE id = 3;
If I use this query to the column that contain backslash, then it will produce null.
Expected result (eg:) :
I'm not sure if I should get rid of the backslash so that the query will produce result or is there any effective way solving it ?.
Thanks a lot
Questioner
Syahirah AR
Viewed
0
