CREATE TABLE Orders(id INTEGER, csv VARCHAR(80));
INSERT INTO Orders(id, csv) VALUES
(1, '0:A:1683481111,1:A:1683481112,2:A:1683481113,3:A:1683481114,4:A:1683481115'),
(2, '0:B:1683481121,1:B:1683481122,2:B:1683481123');
WITH RECURSIVE str_row AS (
SELECT csv
FROM Orders
UNION ALL
SELECT SUBSTRING(csv,16) csv
FROM str_row
WHERE LENGTH(csv) > 14
)
SELECT SUBSTRING(csv,1,14) FROM str_row0:A:1683481111
0:B:1683481121
1:A:1683481112
1:B:1683481122
2:A:1683481113
2:B:1683481123
3:A:1683481114
4:A:1683481115SELECT o.*
FROM Orders o
WHERE o.csv[*][2] >= NOW();CREATE TABLE Orders(id INTEGER, jsons VARCHAR(30));
INSERT INTO Orders(id, jsons) VALUES
(1, '{"1":1,"2":1,"72":3}'),
(2, '{"11":1,"23":1}');
CREATE TABLE Attr(id INTEGER, val VARCHAR(30));
INSERT INTO Attr(id, val) VALUES
(1, 'Один'),
(2, 'Два'),
(3, 'Три'),
(4, 'Четыре');
SELECT o.*, a.*
FROM Orders o
JOIN JSON_TABLE(o.jsons, '$.*' COLUMNS(`child` INT PATH '$') ) as js
JOIN Attr a ON a.id = js.`child`;{"1":1,"2":1,"72":3} и как {"11":1,"23":1}CREATE TABLE Orders(id INTEGER, jsons VARCHAR(30));
INSERT INTO Orders(id, jsons) VALUES
(1, '{"1":1,"2":1,"72":3}'),
(2, '{"11":1,"23":1}');
SELECT o.*, a.*
FROM Orders o
JOIN JSON_TABLE(o.jsons, '$.*' COLUMNS(`child` INT PATH '$') ) as js
JOIN Attr a ON a.attr_id = js.`child`;['value_id'=>'attritute_id', ...... ];
$format_string = '{"one":"%s"}';
echo sprintf($format_string , json_encode ($html));echo '{"content":'.json_encode ($html) .'}';