MariaDB 10.9

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE IF NOT EXISTS brands (
    name VARCHAR(255) NOT NULL,
    sold longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL
);

INSERT INTO brands (name, sold)
VALUES
(
	'test', '[{"id":"0","name":"0","count":5000},{"id":"1","name":"1","count":5000}]'
),(
	'test2', '[{"id":"0","name":"0","count":10000},{"id":"1","name":"1","count":10000}]'
),(
	'test3', '[{"id":"0","name":"0","count":15000},{"id":"1","name":"1","count":15000}]'
),(
	'test4', '[{"id":"0","name":"0","count":700},{"id":"1","name":"1","count":700}]'
);

Records: 4  Duplicates: 0  Warnings: 0


SELECT name, JSON_EXTRACT(sold, '$[*].count') as cnt FROM brands;


name
cnt


test
[5000, 5000]

test2
10000

test3
15000

test4
700


SELECT name, JSON_EXTRACT(sold, '$**.count') as cnt FROM brands;


name
cnt


test
[5000, 5000]

test2
10000

test3
15000

test4
700