MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE mytable (
Item INT, tags JSON);
INSERT INTO mytable VALUES
(1000,'["klmnopqrstuvwxyz", "efghijklmnopqrstuvwxyz", "fghijklmnopqrstuvwxyz"]'),
(2000,'["efghijklmnopqrstuvwxyz", "efghijklmnopqrstuvwxyz", "cdefghijklmnopqrstuvwxyz"]'),
(3000,'["bcdefghijklmnopqrstuvwxyz", "abcdefghijklmnopqrstuvwxyz", "efghijklmnopqrstuvwxyz", "ghijklmnopqrstuvwxyz"]'),
(4000,'["fghij", "klmnopqrstuvwxyz", "cdefghijklmnopqrstuvwxyz"]'),
(5000,'["cd", "ghijklmnopqrstuvwxyz", "klmnopqrstuvwxyz"]'),
(6000,'["ijklmnopqrs", "defghijklmnopqrstuvwxyz", "ghijklmnopqrstuvwxyz", "ghijklmnopqrstuvwxyz"]'),
(7000,'["hijklmnopqrstuvwxyz", "efghijklmnopqrstuvwxyz", "abcdefghijklmnopqrstuvwxyz"]'),
(8000,'["ghijklmnopqrstu", "abcdefghijklmnopqrstuvwxyz", "abcdefghijklmnopqrstuvwxyz"]'),
(9000,'["klmnopqrstuvwxyz", "ijklmnopqrstuvwxyz", "lmnopqrstuvwxyz", "efghijklmnopqrstuvw", "ijklmnopqrstuvwxyz", "jklmnopqrstuvwxyz", "abcdefghijklmnopqrstuvwxyz"]'),
(10000,'["defghijklmno", "hijklmnopqrstuvwxyz", "klmnopqrstuvwxyz"]'),
(11000,'["jklmnopqrstuvwxyz", "fghijklmnopqrstuvwxyz", "cdefghijklmnopqrstuvwxyz"]'),
(12000,'["efg", "lmnopqrstuvwxyz", "klmnopqrstuvwxyz", "ijklmnopqrstuvwxyz"]'),
(13000,'["fghijklmnopqrstuv", "efghijklmnopqrstuvwxyz", "ghijklmnopqrstuvwxyz"]'),
(14000,'["efghijklmnopqrstuvwxyz", "fghijklmnopqrstuvwxyz", "jklmnopqrstuvwxyz"]'),
(15000,'["efghijklmnopqrstuvwxyz", "abcdefghijklmnopqrstuvwxyz", "klmnopqrstuvwxyz", "abcdefghijklmnopqrstuvwxyz"]'),
(16000,'["hijklmnopqrstuvwxyz", "ijklmnopqrstuvwxyz", "ijkl"]'),
(17000,'["cdefghijklmnopqrstuvwxyz", "bcdefghijklmnopqrstuvwxyz", "ijklmnopqrstuvwxyz"]'),
(18000,'["hijklmnopqrst", "ijklmnopqrstuvwxyz", "klmnopqrstuvwxyz", "ghijklmnopqrstuvw"]'),
(19000,'["cdefghijklmnopqrstuvwxyz", "cdefghijklmnopqrstuvwxyz", "klmnopqrstuvwxyz"]'),
(20000,'["hijklmnopqrstuvwxyz", "bcdefghijklm", "defghij"]'),
(21000,'["fghijklmnopq", "cdefghijklmnopqrstuvwxyz", "efghijklmnopqrstuvwxyz", "jklmnopqrstuvwxyz"]'),
(22000,'["defghijklmnopqrstuvwxyz", "jklmnopqrstuvwxyz", "jklmnopqrs"]'),
(23000,'["bcdefghijklmnopqrstuvw", "jklmnopqrstuvwxyz", "cdefghijklmnopq"]'),
(24000,'["abcdefghijklmnopqrstuvwxyz", "klmnop", "hijklmnopqrstuvwxyz", "efghijklmnopqrstuvwxyz"]'),
(25000,'["klmnopqrstuvwxyz", "jklmnopqrstuvwxyz", "ghijklmnopqrstuvwxyz"]'),
(26000,'["klmnopqrstuvwxyz", "defghijklmnopqrstuvwxyz", "lmnopqrstuvwxyz"]'),
(27000,'["cdefghijklmnopqrstuvwxyz", "lmnopqrstuvwxyz", "bcdefghijklmnopqrstuvwxyz", "efghijklmnopqrstuvwxyz"]'),
(28000,'["cdefghijklmnopqrstuvwxyz", "jklmnopqrst", "bcdefghijklmnopqrstuvwxyz"]'),
(29000,'["defghijklmnopqrstuvwxyz", "jklmnopqrstuvwxyz", "efghijklmnopqrstuvwxyz"]');

WITH RECURSIVE tblrows AS(
SELECT 0 AS rnum, MAX((LENGTH(t)-LENGTH(REPLACE(t,',',''))) +1) AS maxtags
FROM
(SELECT Item, JSON_UNQUOTE(tags) AS t FROM mytable) A UNION ALL
SELECT rnum+1, maxtags FROM tblrows WHERE rnum+1 <= maxtags)
SELECT rnum, item, JSON_UNQUOTE(tags),
       JSON_EXTRACT(tags, CONCAT('$[', rnum, ']')) AS tagsVal
FROM
    tblrows t CROSS JOIN mytable m


rnum
item
JSON_UNQUOTE(tags)
tagsVal


7
1000
["klmnopqrstuvwxyz", "efghijklmnopqrstuvwxyz", "fghijklmnopqrstuvwxyz"]
null

6
1000
["klmnopqrstuvwxyz", "efghijklmnopqrstuvwxyz", "fghijklmnopqrstuvwxyz"]
null

5
1000
["klmnopqrstuvwxyz", "efghijklmnopqrstuvwxyz", "fghijklmnopqrstuvwxyz"]
null

4
1000
["klmnopqrstuvwxyz", "efghijklmnopqrstuvwxyz", "fghijklmnopqrstuvwxyz"]
null

3
1000
["klmnopqrstuvwxyz", "efghijklmnopqrstuvwxyz", "fghijklmnopqrstuvwxyz"]
null

2
1000
["klmnopqrstuvwxyz", "efghijklmnopqrstuvwxyz", "fghijklmnopqrstuvwxyz"]
"fghijklmnopqrstuvwxyz"

1
1000
["klmnopqrstuvwxyz", "efghijklmnopqrstuvwxyz", "fghijklmnopqrstuvwxyz"]
"efghijklmnopqrstuvwxyz"

0
1000
["klmnopqrstuvwxyz", "efghijklmnopqrstuvwxyz", "fghijklmnopqrstuvwxyz"]
"klmnopqrstuvwxyz"

7
2000
["efghijklmnopqrstuvwxyz", "efghijklmnopqrstuvwxyz", "cdefghijklmnopqrstuvwxyz"]
null

6
2000
["efghijklmnopqrstuvwxyz", "efghijklmnopqrstuvwxyz", "cdefghijklmnopqrstuvwxyz"]
null

5
2000
["efghijklmnopqrstuvwxyz", "efghijklmnopqrstuvwxyz", "cdefghijklmnopqrstuvwxyz"]
null

4
2000
["efghijklmnopqrstuvwxyz", "efghijklmnopqrstuvwxyz", "cdefghijklmnopqrstuvwxyz"]
null

3
2000
["efghijklmnopqrstuvwxyz", "efghijklmnopqrstuvwxyz", "cdefghijklmnopqrstuvwxyz"]
null

2
2000
["efghijklmnopqrstuvwxyz", "efghijklmnopqrstuvwxyz", "cdefghijklmnopqrstuvwxyz"]
"cdefghijklmnopqrstuvwxyz"

1
2000
["efghijklmnopqrstuvwxyz", "efghijklmnopqrstuvwxyz", "cdefghijklmnopqrstuvwxyz"]
"efghijklmnopqrstuvwxyz"

0
2000
["efghijklmnopqrstuvwxyz", "efghijklmnopqrstuvwxyz", "cdefghijklmnopqrstuvwxyz"]
"efghijklmnopqrstuvwxyz"

7
3000
["bcdefghijklmnopqrstuvwxyz", "abcdefghijklmnopqrstuvwxyz", "efghijklmnopqrstuvwxyz", "ghijklmnopqrstuvwxyz"]
null

6
3000
["bcdefghijklmnopqrstuvwxyz", "abcdefghijklmnopqrstuvwxyz", "efghijklmnopqrstuvwxyz", "ghijklmnopqrstuvwxyz"]
null

5
3000
["bcdefghijklmnopqrstuvwxyz", "abcdefghijklmnopqrstuvwxyz", "efghijklmnopqrstuvwxyz", "ghijklmnopqrstuvwxyz"]
null

4
3000
["bcdefghijklmnopqrstuvwxyz", "abcdefghijklmnopqrstuvwxyz", "efghijklmnopqrstuvwxyz", "ghijklmnopqrstuvwxyz"]
null

3
3000
["bcdefghijklmnopqrstuvwxyz", "abcdefghijklmnopqrstuvwxyz", "efghijklmnopqrstuvwxyz", "ghijklmnopqrstuvwxyz"]
"ghijklmnopqrstuvwxyz"

2
3000
["bcdefghijklmnopqrstuvwxyz", "abcdefghijklmnopqrstuvwxyz", "efghijklmnopqrstuvwxyz", "ghijklmnopqrstuvwxyz"]
"efghijklmnopqrstuvwxyz"

1
3000
["bcdefghijklmnopqrstuvwxyz", "abcdefghijklmnopqrstuvwxyz", "efghijklmnopqrstuvwxyz", "ghijklmnopqrstuvwxyz"]
"abcdefghijklmnopqrstuvwxyz"

0
3000
["bcdefghijklmnopqrstuvwxyz", "abcdefghijklmnopqrstuvwxyz", "efghijklmnopqrstuvwxyz", "ghijklmnopqrstuvwxyz"]
"bcdefghijklmnopqrstuvwxyz"

7
4000
["fghij", "klmnopqrstuvwxyz", "cdefghijklmnopqrstuvwxyz"]
null

6
4000
["fghij", "klmnopqrstuvwxyz", "cdefghijklmnopqrstuvwxyz"]
null

5
4000
["fghij", "klmnopqrstuvwxyz", "cdefghijklmnopqrstuvwxyz"]
null

4
4000
["fghij", "klmnopqrstuvwxyz", "cdefghijklmnopqrstuvwxyz"]
null

3
4000
["fghij", "klmnopqrstuvwxyz", "cdefghijklmnopqrstuvwxyz"]
null

2
4000
["fghij", "klmnopqrstuvwxyz", "cdefghijklmnopqrstuvwxyz"]
"cdefghijklmnopqrstuvwxyz"

1
4000
["fghij", "klmnopqrstuvwxyz", "cdefghijklmnopqrstuvwxyz"]
"klmnopqrstuvwxyz"

0
4000
["fghij", "klmnopqrstuvwxyz", "cdefghijklmnopqrstuvwxyz"]
"fghij"

7
5000
["cd", "ghijklmnopqrstuvwxyz", "klmnopqrstuvwxyz"]
null

6
5000
["cd", "ghijklmnopqrstuvwxyz", "klmnopqrstuvwxyz"]
null

5
5000
["cd", "ghijklmnopqrstuvwxyz", "klmnopqrstuvwxyz"]
null

4
5000
["cd", "ghijklmnopqrstuvwxyz", "klmnopqrstuvwxyz"]
null

3
5000
["cd", "ghijklmnopqrstuvwxyz", "klmnopqrstuvwxyz"]
null

2
5000
["cd", "ghijklmnopqrstuvwxyz", "klmnopqrstuvwxyz"]
"klmnopqrstuvwxyz"

1
5000
["cd", "ghijklmnopqrstuvwxyz", "klmnopqrstuvwxyz"]
"ghijklmnopqrstuvwxyz"

0
5000
["cd", "ghijklmnopqrstuvwxyz", "klmnopqrstuvwxyz"]
"cd"

7
6000
["ijklmnopqrs", "defghijklmnopqrstuvwxyz", "ghijklmnopqrstuvwxyz", "ghijklmnopqrstuvwxyz"]
null

6
6000
["ijklmnopqrs", "defghijklmnopqrstuvwxyz", "ghijklmnopqrstuvwxyz", "ghijklmnopqrstuvwxyz"]
null

5
6000
["ijklmnopqrs", "defghijklmnopqrstuvwxyz", "ghijklmnopqrstuvwxyz", "ghijklmnopqrstuvwxyz"]
null

4
6000
["ijklmnopqrs", "defghijklmnopqrstuvwxyz", "ghijklmnopqrstuvwxyz", "ghijklmnopqrstuvwxyz"]
null

3
6000
["ijklmnopqrs", "defghijklmnopqrstuvwxyz", "ghijklmnopqrstuvwxyz", "ghijklmnopqrstuvwxyz"]
"ghijklmnopqrstuvwxyz"

2
6000
["ijklmnopqrs", "defghijklmnopqrstuvwxyz", "ghijklmnopqrstuvwxyz", "ghijklmnopqrstuvwxyz"]
"ghijklmnopqrstuvwxyz"

1
6000
["ijklmnopqrs", "defghijklmnopqrstuvwxyz", "ghijklmnopqrstuvwxyz", "ghijklmnopqrstuvwxyz"]
"defghijklmnopqrstuvwxyz"

0
6000
["ijklmnopqrs", "defghijklmnopqrstuvwxyz", "ghijklmnopqrstuvwxyz", "ghijklmnopqrstuvwxyz"]
"ijklmnopqrs"

7
7000
["hijklmnopqrstuvwxyz", "efghijklmnopqrstuvwxyz", "abcdefghijklmnopqrstuvwxyz"]
null

6
7000
["hijklmnopqrstuvwxyz", "efghijklmnopqrstuvwxyz", "abcdefghijklmnopqrstuvwxyz"]
null

5
7000
["hijklmnopqrstuvwxyz", "efghijklmnopqrstuvwxyz", "abcdefghijklmnopqrstuvwxyz"]
null

4
7000
["hijklmnopqrstuvwxyz", "efghijklmnopqrstuvwxyz", "abcdefghijklmnopqrstuvwxyz"]
null

3
7000
["hijklmnopqrstuvwxyz", "efghijklmnopqrstuvwxyz", "abcdefghijklmnopqrstuvwxyz"]
null

2
7000
["hijklmnopqrstuvwxyz", "efghijklmnopqrstuvwxyz", "abcdefghijklmnopqrstuvwxyz"]
"abcdefghijklmnopqrstuvwxyz"

1
7000
["hijklmnopqrstuvwxyz", "efghijklmnopqrstuvwxyz", "abcdefghijklmnopqrstuvwxyz"]
"efghijklmnopqrstuvwxyz"

0
7000
["hijklmnopqrstuvwxyz", "efghijklmnopqrstuvwxyz", "abcdefghijklmnopqrstuvwxyz"]
"hijklmnopqrstuvwxyz"

7
8000
["ghijklmnopqrstu", "abcdefghijklmnopqrstuvwxyz", "abcdefghijklmnopqrstuvwxyz"]
null

6
8000
["ghijklmnopqrstu", "abcdefghijklmnopqrstuvwxyz", "abcdefghijklmnopqrstuvwxyz"]
null

5
8000
["ghijklmnopqrstu", "abcdefghijklmnopqrstuvwxyz", "abcdefghijklmnopqrstuvwxyz"]
null

4
8000
["ghijklmnopqrstu", "abcdefghijklmnopqrstuvwxyz", "abcdefghijklmnopqrstuvwxyz"]
null

3
8000
["ghijklmnopqrstu", "abcdefghijklmnopqrstuvwxyz", "abcdefghijklmnopqrstuvwxyz"]
null

2
8000
["ghijklmnopqrstu", "abcdefghijklmnopqrstuvwxyz", "abcdefghijklmnopqrstuvwxyz"]
"abcdefghijklmnopqrstuvwxyz"

1
8000
["ghijklmnopqrstu", "abcdefghijklmnopqrstuvwxyz", "abcdefghijklmnopqrstuvwxyz"]
"abcdefghijklmnopqrstuvwxyz"

0
8000
["ghijklmnopqrstu", "abcdefghijklmnopqrstuvwxyz", "abcdefghijklmnopqrstuvwxyz"]
"ghijklmnopqrstu"

7
9000
["klmnopqrstuvwxyz", "ijklmnopqrstuvwxyz", "lmnopqrstuvwxyz", "efghijklmnopqrstuvw", "ijklmnopqrstuvwxyz", "jklmnopqrstuvwxyz", "abcdefghijklmnopqrstuvwxyz"]
null

6
9000
["klmnopqrstuvwxyz", "ijklmnopqrstuvwxyz", "lmnopqrstuvwxyz", "efghijklmnopqrstuvw", "ijklmnopqrstuvwxyz", "jklmnopqrstuvwxyz", "abcdefghijklmnopqrstuvwxyz"]
"abcdefghijklmnopqrstuvwxyz"

5
9000
["klmnopqrstuvwxyz", "ijklmnopqrstuvwxyz", "lmnopqrstuvwxyz", "efghijklmnopqrstuvw", "ijklmnopqrstuvwxyz", "jklmnopqrstuvwxyz", "abcdefghijklmnopqrstuvwxyz"]
"jklmnopqrstuvwxyz"

4
9000
["klmnopqrstuvwxyz", "ijklmnopqrstuvwxyz", "lmnopqrstuvwxyz", "efghijklmnopqrstuvw", "ijklmnopqrstuvwxyz", "jklmnopqrstuvwxyz", "abcdefghijklmnopqrstuvwxyz"]
"ijklmnopqrstuvwxyz"

3
9000
["klmnopqrstuvwxyz", "ijklmnopqrstuvwxyz", "lmnopqrstuvwxyz", "efghijklmnopqrstuvw", "ijklmnopqrstuvwxyz", "jklmnopqrstuvwxyz", "abcdefghijklmnopqrstuvwxyz"]
"efghijklmnopqrstuvw"

2
9000
["klmnopqrstuvwxyz", "ijklmnopqrstuvwxyz", "lmnopqrstuvwxyz", "efghijklmnopqrstuvw", "ijklmnopqrstuvwxyz", "jklmnopqrstuvwxyz", "abcdefghijklmnopqrstuvwxyz"]
"lmnopqrstuvwxyz"

1
9000
["klmnopqrstuvwxyz", "ijklmnopqrstuvwxyz", "lmnopqrstuvwxyz", "efghijklmnopqrstuvw", "ijklmnopqrstuvwxyz", "jklmnopqrstuvwxyz", "abcdefghijklmnopqrstuvwxyz"]
"ijklmnopqrstuvwxyz"

0
9000
["klmnopqrstuvwxyz", "ijklmnopqrstuvwxyz", "lmnopqrstuvwxyz", "efghijklmnopqrstuvw", "ijklmnopqrstuvwxyz", "jklmnopqrstuvwxyz", "abcdefghijklmnopqrstuvwxyz"]
"klmnopqrstuvwxyz"

7
10000
["defghijklmno", "hijklmnopqrstuvwxyz", "klmnopqrstuvwxyz"]
null

6
10000
["defghijklmno", "hijklmnopqrstuvwxyz", "klmnopqrstuvwxyz"]
null

5
10000
["defghijklmno", "hijklmnopqrstuvwxyz", "klmnopqrstuvwxyz"]
null

4
10000
["defghijklmno", "hijklmnopqrstuvwxyz", "klmnopqrstuvwxyz"]
null

3
10000
["defghijklmno", "hijklmnopqrstuvwxyz", "klmnopqrstuvwxyz"]
null

2
10000
["defghijklmno", "hijklmnopqrstuvwxyz", "klmnopqrstuvwxyz"]
"klmnopqrstuvwxyz"

1
10000
["defghijklmno", "hijklmnopqrstuvwxyz", "klmnopqrstuvwxyz"]
"hijklmnopqrstuvwxyz"

0
10000
["defghijklmno", "hijklmnopqrstuvwxyz", "klmnopqrstuvwxyz"]
"defghijklmno"

7
11000
["jklmnopqrstuvwxyz", "fghijklmnopqrstuvwxyz", "cdefghijklmnopqrstuvwxyz"]
null

6
11000
["jklmnopqrstuvwxyz", "fghijklmnopqrstuvwxyz", "cdefghijklmnopqrstuvwxyz"]
null

5
11000
["jklmnopqrstuvwxyz", "fghijklmnopqrstuvwxyz", "cdefghijklmnopqrstuvwxyz"]
null

4
11000
["jklmnopqrstuvwxyz", "fghijklmnopqrstuvwxyz", "cdefghijklmnopqrstuvwxyz"]
null

3
11000
["jklmnopqrstuvwxyz", "fghijklmnopqrstuvwxyz", "cdefghijklmnopqrstuvwxyz"]
null

2
11000
["jklmnopqrstuvwxyz", "fghijklmnopqrstuvwxyz", "cdefghijklmnopqrstuvwxyz"]
"cdefghijklmnopqrstuvwxyz"

1
11000
["jklmnopqrstuvwxyz", "fghijklmnopqrstuvwxyz", "cdefghijklmnopqrstuvwxyz"]
"fghijklmnopqrstuvwxyz"

0
11000
["jklmnopqrstuvwxyz", "fghijklmnopqrstuvwxyz", "cdefghijklmnopqrstuvwxyz"]
"jklmnopqrstuvwxyz"

7
12000
["efg", "lmnopqrstuvwxyz", "klmnopqrstuvwxyz", "ijklmnopqrstuvwxyz"]
null

6
12000
["efg", "lmnopqrstuvwxyz", "klmnopqrstuvwxyz", "ijklmnopqrstuvwxyz"]
null

5
12000
["efg", "lmnopqrstuvwxyz", "klmnopqrstuvwxyz", "ijklmnopqrstuvwxyz"]
null

4
12000
["efg", "lmnopqrstuvwxyz", "klmnopqrstuvwxyz", "ijklmnopqrstuvwxyz"]
null

3
12000
["efg", "lmnopqrstuvwxyz", "klmnopqrstuvwxyz", "ijklmnopqrstuvwxyz"]
"ijklmnopqrstuvwxyz"

2
12000
["efg", "lmnopqrstuvwxyz", "klmnopqrstuvwxyz", "ijklmnopqrstuvwxyz"]
"klmnopqrstuvwxyz"

1
12000
["efg", "lmnopqrstuvwxyz", "klmnopqrstuvwxyz", "ijklmnopqrstuvwxyz"]
"lmnopqrstuvwxyz"

0
12000
["efg", "lmnopqrstuvwxyz", "klmnopqrstuvwxyz", "ijklmnopqrstuvwxyz"]
"efg"

7
13000
["fghijklmnopqrstuv", "efghijklmnopqrstuvwxyz", "ghijklmnopqrstuvwxyz"]
null

6
13000
["fghijklmnopqrstuv", "efghijklmnopqrstuvwxyz", "ghijklmnopqrstuvwxyz"]
null

5
13000
["fghijklmnopqrstuv", "efghijklmnopqrstuvwxyz", "ghijklmnopqrstuvwxyz"]
null

4
13000
["fghijklmnopqrstuv", "efghijklmnopqrstuvwxyz", "ghijklmnopqrstuvwxyz"]
null

3
13000
["fghijklmnopqrstuv", "efghijklmnopqrstuvwxyz", "ghijklmnopqrstuvwxyz"]
null

2
13000
["fghijklmnopqrstuv", "efghijklmnopqrstuvwxyz", "ghijklmnopqrstuvwxyz"]
"ghijklmnopqrstuvwxyz"

1
13000
["fghijklmnopqrstuv", "efghijklmnopqrstuvwxyz", "ghijklmnopqrstuvwxyz"]
"efghijklmnopqrstuvwxyz"

0
13000
["fghijklmnopqrstuv", "efghijklmnopqrstuvwxyz", "ghijklmnopqrstuvwxyz"]
"fghijklmnopqrstuv"

7
14000
["efghijklmnopqrstuvwxyz", "fghijklmnopqrstuvwxyz", "jklmnopqrstuvwxyz"]
null

6
14000
["efghijklmnopqrstuvwxyz", "fghijklmnopqrstuvwxyz", "jklmnopqrstuvwxyz"]
null

5
14000
["efghijklmnopqrstuvwxyz", "fghijklmnopqrstuvwxyz", "jklmnopqrstuvwxyz"]
null

4
14000
["efghijklmnopqrstuvwxyz", "fghijklmnopqrstuvwxyz", "jklmnopqrstuvwxyz"]
null

3
14000
["efghijklmnopqrstuvwxyz", "fghijklmnopqrstuvwxyz", "jklmnopqrstuvwxyz"]
null

2
14000
["efghijklmnopqrstuvwxyz", "fghijklmnopqrstuvwxyz", "jklmnopqrstuvwxyz"]
"jklmnopqrstuvwxyz"

1
14000
["efghijklmnopqrstuvwxyz", "fghijklmnopqrstuvwxyz", "jklmnopqrstuvwxyz"]
"fghijklmnopqrstuvwxyz"

0
14000
["efghijklmnopqrstuvwxyz", "fghijklmnopqrstuvwxyz", "jklmnopqrstuvwxyz"]
"efghijklmnopqrstuvwxyz"

7
15000
["efghijklmnopqrstuvwxyz", "abcdefghijklmnopqrstuvwxyz", "klmnopqrstuvwxyz", "abcdefghijklmnopqrstuvwxyz"]
null

6
15000
["efghijklmnopqrstuvwxyz", "abcdefghijklmnopqrstuvwxyz", "klmnopqrstuvwxyz", "abcdefghijklmnopqrstuvwxyz"]
null

5
15000
["efghijklmnopqrstuvwxyz", "abcdefghijklmnopqrstuvwxyz", "klmnopqrstuvwxyz", "abcdefghijklmnopqrstuvwxyz"]
null

4
15000
["efghijklmnopqrstuvwxyz", "abcdefghijklmnopqrstuvwxyz", "klmnopqrstuvwxyz", "abcdefghijklmnopqrstuvwxyz"]
null

3
15000
["efghijklmnopqrstuvwxyz", "abcdefghijklmnopqrstuvwxyz", "klmnopqrstuvwxyz", "abcdefghijklmnopqrstuvwxyz"]
"abcdefghijklmnopqrstuvwxyz"

2
15000
["efghijklmnopqrstuvwxyz", "abcdefghijklmnopqrstuvwxyz", "klmnopqrstuvwxyz", "abcdefghijklmnopqrstuvwxyz"]
"klmnopqrstuvwxyz"

1
15000
["efghijklmnopqrstuvwxyz", "abcdefghijklmnopqrstuvwxyz", "klmnopqrstuvwxyz", "abcdefghijklmnopqrstuvwxyz"]
"abcdefghijklmnopqrstuvwxyz"

0
15000
["efghijklmnopqrstuvwxyz", "abcdefghijklmnopqrstuvwxyz", "klmnopqrstuvwxyz", "abcdefghijklmnopqrstuvwxyz"]
"efghijklmnopqrstuvwxyz"

7
16000
["hijklmnopqrstuvwxyz", "ijklmnopqrstuvwxyz", "ijkl"]
null

6
16000
["hijklmnopqrstuvwxyz", "ijklmnopqrstuvwxyz", "ijkl"]
null

5
16000
["hijklmnopqrstuvwxyz", "ijklmnopqrstuvwxyz", "ijkl"]
null

4
16000
["hijklmnopqrstuvwxyz", "ijklmnopqrstuvwxyz", "ijkl"]
null

3
16000
["hijklmnopqrstuvwxyz", "ijklmnopqrstuvwxyz", "ijkl"]
null

2
16000
["hijklmnopqrstuvwxyz", "ijklmnopqrstuvwxyz", "ijkl"]
"ijkl"

1
16000
["hijklmnopqrstuvwxyz", "ijklmnopqrstuvwxyz", "ijkl"]
"ijklmnopqrstuvwxyz"

0
16000
["hijklmnopqrstuvwxyz", "ijklmnopqrstuvwxyz", "ijkl"]
"hijklmnopqrstuvwxyz"

7
17000
["cdefghijklmnopqrstuvwxyz", "bcdefghijklmnopqrstuvwxyz", "ijklmnopqrstuvwxyz"]
null

6
17000
["cdefghijklmnopqrstuvwxyz", "bcdefghijklmnopqrstuvwxyz", "ijklmnopqrstuvwxyz"]
null

5
17000
["cdefghijklmnopqrstuvwxyz", "bcdefghijklmnopqrstuvwxyz", "ijklmnopqrstuvwxyz"]
null

4
17000
["cdefghijklmnopqrstuvwxyz", "bcdefghijklmnopqrstuvwxyz", "ijklmnopqrstuvwxyz"]
null

3
17000
["cdefghijklmnopqrstuvwxyz", "bcdefghijklmnopqrstuvwxyz", "ijklmnopqrstuvwxyz"]
null

2
17000
["cdefghijklmnopqrstuvwxyz", "bcdefghijklmnopqrstuvwxyz", "ijklmnopqrstuvwxyz"]
"ijklmnopqrstuvwxyz"

1
17000
["cdefghijklmnopqrstuvwxyz", "bcdefghijklmnopqrstuvwxyz", "ijklmnopqrstuvwxyz"]
"bcdefghijklmnopqrstuvwxyz"

0
17000
["cdefghijklmnopqrstuvwxyz", "bcdefghijklmnopqrstuvwxyz", "ijklmnopqrstuvwxyz"]
"cdefghijklmnopqrstuvwxyz"

7
18000
["hijklmnopqrst", "ijklmnopqrstuvwxyz", "klmnopqrstuvwxyz", "ghijklmnopqrstuvw"]
null

6
18000
["hijklmnopqrst", "ijklmnopqrstuvwxyz", "klmnopqrstuvwxyz", "ghijklmnopqrstuvw"]
null

5
18000
["hijklmnopqrst", "ijklmnopqrstuvwxyz", "klmnopqrstuvwxyz", "ghijklmnopqrstuvw"]
null

4
18000
["hijklmnopqrst", "ijklmnopqrstuvwxyz", "klmnopqrstuvwxyz", "ghijklmnopqrstuvw"]
null

3
18000
["hijklmnopqrst", "ijklmnopqrstuvwxyz", "klmnopqrstuvwxyz", "ghijklmnopqrstuvw"]
"ghijklmnopqrstuvw"

2
18000
["hijklmnopqrst", "ijklmnopqrstuvwxyz", "klmnopqrstuvwxyz", "ghijklmnopqrstuvw"]
"klmnopqrstuvwxyz"

1
18000
["hijklmnopqrst", "ijklmnopqrstuvwxyz", "klmnopqrstuvwxyz", "ghijklmnopqrstuvw"]
"ijklmnopqrstuvwxyz"

0
18000
["hijklmnopqrst", "ijklmnopqrstuvwxyz", "klmnopqrstuvwxyz", "ghijklmnopqrstuvw"]
"hijklmnopqrst"

7
19000
["cdefghijklmnopqrstuvwxyz", "cdefghijklmnopqrstuvwxyz", "klmnopqrstuvwxyz"]
null

6
19000
["cdefghijklmnopqrstuvwxyz", "cdefghijklmnopqrstuvwxyz", "klmnopqrstuvwxyz"]
null

5
19000
["cdefghijklmnopqrstuvwxyz", "cdefghijklmnopqrstuvwxyz", "klmnopqrstuvwxyz"]
null

4
19000
["cdefghijklmnopqrstuvwxyz", "cdefghijklmnopqrstuvwxyz", "klmnopqrstuvwxyz"]
null

3
19000
["cdefghijklmnopqrstuvwxyz", "cdefghijklmnopqrstuvwxyz", "klmnopqrstuvwxyz"]
null

2
19000
["cdefghijklmnopqrstuvwxyz", "cdefghijklmnopqrstuvwxyz", "klmnopqrstuvwxyz"]
"klmnopqrstuvwxyz"

1
19000
["cdefghijklmnopqrstuvwxyz", "cdefghijklmnopqrstuvwxyz", "klmnopqrstuvwxyz"]
"cdefghijklmnopqrstuvwxyz"

0
19000
["cdefghijklmnopqrstuvwxyz", "cdefghijklmnopqrstuvwxyz", "klmnopqrstuvwxyz"]
"cdefghijklmnopqrstuvwxyz"

7
20000
["hijklmnopqrstuvwxyz", "bcdefghijklm", "defghij"]
null

6
20000
["hijklmnopqrstuvwxyz", "bcdefghijklm", "defghij"]
null

5
20000
["hijklmnopqrstuvwxyz", "bcdefghijklm", "defghij"]
null

4
20000
["hijklmnopqrstuvwxyz", "bcdefghijklm", "defghij"]
null

3
20000
["hijklmnopqrstuvwxyz", "bcdefghijklm", "defghij"]
null

2
20000
["hijklmnopqrstuvwxyz", "bcdefghijklm", "defghij"]
"defghij"

1
20000
["hijklmnopqrstuvwxyz", "bcdefghijklm", "defghij"]
"bcdefghijklm"

0
20000
["hijklmnopqrstuvwxyz", "bcdefghijklm", "defghij"]
"hijklmnopqrstuvwxyz"

7
21000
["fghijklmnopq", "cdefghijklmnopqrstuvwxyz", "efghijklmnopqrstuvwxyz", "jklmnopqrstuvwxyz"]
null

6
21000
["fghijklmnopq", "cdefghijklmnopqrstuvwxyz", "efghijklmnopqrstuvwxyz", "jklmnopqrstuvwxyz"]
null

5
21000
["fghijklmnopq", "cdefghijklmnopqrstuvwxyz", "efghijklmnopqrstuvwxyz", "jklmnopqrstuvwxyz"]
null

4
21000
["fghijklmnopq", "cdefghijklmnopqrstuvwxyz", "efghijklmnopqrstuvwxyz", "jklmnopqrstuvwxyz"]
null

3
21000
["fghijklmnopq", "cdefghijklmnopqrstuvwxyz", "efghijklmnopqrstuvwxyz", "jklmnopqrstuvwxyz"]
"jklmnopqrstuvwxyz"

2
21000
["fghijklmnopq", "cdefghijklmnopqrstuvwxyz", "efghijklmnopqrstuvwxyz", "jklmnopqrstuvwxyz"]
"efghijklmnopqrstuvwxyz"

1
21000
["fghijklmnopq", "cdefghijklmnopqrstuvwxyz", "efghijklmnopqrstuvwxyz", "jklmnopqrstuvwxyz"]
"cdefghijklmnopqrstuvwxyz"

0
21000
["fghijklmnopq", "cdefghijklmnopqrstuvwxyz", "efghijklmnopqrstuvwxyz", "jklmnopqrstuvwxyz"]
"fghijklmnopq"

7
22000
["defghijklmnopqrstuvwxyz", "jklmnopqrstuvwxyz", "jklmnopqrs"]
null

6
22000
["defghijklmnopqrstuvwxyz", "jklmnopqrstuvwxyz", "jklmnopqrs"]
null

5
22000
["defghijklmnopqrstuvwxyz", "jklmnopqrstuvwxyz", "jklmnopqrs"]
null

4
22000
["defghijklmnopqrstuvwxyz", "jklmnopqrstuvwxyz", "jklmnopqrs"]
null

3
22000
["defghijklmnopqrstuvwxyz", "jklmnopqrstuvwxyz", "jklmnopqrs"]
null

2
22000
["defghijklmnopqrstuvwxyz", "jklmnopqrstuvwxyz", "jklmnopqrs"]
"jklmnopqrs"

1
22000
["defghijklmnopqrstuvwxyz", "jklmnopqrstuvwxyz", "jklmnopqrs"]
"jklmnopqrstuvwxyz"

0
22000
["defghijklmnopqrstuvwxyz", "jklmnopqrstuvwxyz", "jklmnopqrs"]
"defghijklmnopqrstuvwxyz"

7
23000
["bcdefghijklmnopqrstuvw", "jklmnopqrstuvwxyz", "cdefghijklmnopq"]
null

6
23000
["bcdefghijklmnopqrstuvw", "jklmnopqrstuvwxyz", "cdefghijklmnopq"]
null

5
23000
["bcdefghijklmnopqrstuvw", "jklmnopqrstuvwxyz", "cdefghijklmnopq"]
null

4
23000
["bcdefghijklmnopqrstuvw", "jklmnopqrstuvwxyz", "cdefghijklmnopq"]
null

3
23000
["bcdefghijklmnopqrstuvw", "jklmnopqrstuvwxyz", "cdefghijklmnopq"]
null

2
23000
["bcdefghijklmnopqrstuvw", "jklmnopqrstuvwxyz", "cdefghijklmnopq"]
"cdefghijklmnopq"

1
23000
["bcdefghijklmnopqrstuvw", "jklmnopqrstuvwxyz", "cdefghijklmnopq"]
"jklmnopqrstuvwxyz"

0
23000
["bcdefghijklmnopqrstuvw", "jklmnopqrstuvwxyz", "cdefghijklmnopq"]
"bcdefghijklmnopqrstuvw"

7
24000
["abcdefghijklmnopqrstuvwxyz", "klmnop", "hijklmnopqrstuvwxyz", "efghijklmnopqrstuvwxyz"]
null

6
24000
["abcdefghijklmnopqrstuvwxyz", "klmnop", "hijklmnopqrstuvwxyz", "efghijklmnopqrstuvwxyz"]
null

5
24000
["abcdefghijklmnopqrstuvwxyz", "klmnop", "hijklmnopqrstuvwxyz", "efghijklmnopqrstuvwxyz"]
null

4
24000
["abcdefghijklmnopqrstuvwxyz", "klmnop", "hijklmnopqrstuvwxyz", "efghijklmnopqrstuvwxyz"]
null

3
24000
["abcdefghijklmnopqrstuvwxyz", "klmnop", "hijklmnopqrstuvwxyz", "efghijklmnopqrstuvwxyz"]
"efghijklmnopqrstuvwxyz"

2
24000
["abcdefghijklmnopqrstuvwxyz", "klmnop", "hijklmnopqrstuvwxyz", "efghijklmnopqrstuvwxyz"]
"hijklmnopqrstuvwxyz"

1
24000
["abcdefghijklmnopqrstuvwxyz", "klmnop", "hijklmnopqrstuvwxyz", "efghijklmnopqrstuvwxyz"]
"klmnop"

0
24000
["abcdefghijklmnopqrstuvwxyz", "klmnop", "hijklmnopqrstuvwxyz", "efghijklmnopqrstuvwxyz"]
"abcdefghijklmnopqrstuvwxyz"

7
25000
["klmnopqrstuvwxyz", "jklmnopqrstuvwxyz", "ghijklmnopqrstuvwxyz"]
null

6
25000
["klmnopqrstuvwxyz", "jklmnopqrstuvwxyz", "ghijklmnopqrstuvwxyz"]
null

5
25000
["klmnopqrstuvwxyz", "jklmnopqrstuvwxyz", "ghijklmnopqrstuvwxyz"]
null

4
25000
["klmnopqrstuvwxyz", "jklmnopqrstuvwxyz", "ghijklmnopqrstuvwxyz"]
null

3
25000
["klmnopqrstuvwxyz", "jklmnopqrstuvwxyz", "ghijklmnopqrstuvwxyz"]
null

2
25000
["klmnopqrstuvwxyz", "jklmnopqrstuvwxyz", "ghijklmnopqrstuvwxyz"]
"ghijklmnopqrstuvwxyz"

1
25000
["klmnopqrstuvwxyz", "jklmnopqrstuvwxyz", "ghijklmnopqrstuvwxyz"]
"jklmnopqrstuvwxyz"

0
25000
["klmnopqrstuvwxyz", "jklmnopqrstuvwxyz", "ghijklmnopqrstuvwxyz"]
"klmnopqrstuvwxyz"

7
26000
["klmnopqrstuvwxyz", "defghijklmnopqrstuvwxyz", "lmnopqrstuvwxyz"]
null

6
26000
["klmnopqrstuvwxyz", "defghijklmnopqrstuvwxyz", "lmnopqrstuvwxyz"]
null

5
26000
["klmnopqrstuvwxyz", "defghijklmnopqrstuvwxyz", "lmnopqrstuvwxyz"]
null

4
26000
["klmnopqrstuvwxyz", "defghijklmnopqrstuvwxyz", "lmnopqrstuvwxyz"]
null

3
26000
["klmnopqrstuvwxyz", "defghijklmnopqrstuvwxyz", "lmnopqrstuvwxyz"]
null

2
26000
["klmnopqrstuvwxyz", "defghijklmnopqrstuvwxyz", "lmnopqrstuvwxyz"]
"lmnopqrstuvwxyz"

1
26000
["klmnopqrstuvwxyz", "defghijklmnopqrstuvwxyz", "lmnopqrstuvwxyz"]
"defghijklmnopqrstuvwxyz"

0
26000
["klmnopqrstuvwxyz", "defghijklmnopqrstuvwxyz", "lmnopqrstuvwxyz"]
"klmnopqrstuvwxyz"

7
27000
["cdefghijklmnopqrstuvwxyz", "lmnopqrstuvwxyz", "bcdefghijklmnopqrstuvwxyz", "efghijklmnopqrstuvwxyz"]
null

6
27000
["cdefghijklmnopqrstuvwxyz", "lmnopqrstuvwxyz", "bcdefghijklmnopqrstuvwxyz", "efghijklmnopqrstuvwxyz"]
null

5
27000
["cdefghijklmnopqrstuvwxyz", "lmnopqrstuvwxyz", "bcdefghijklmnopqrstuvwxyz", "efghijklmnopqrstuvwxyz"]
null

4
27000
["cdefghijklmnopqrstuvwxyz", "lmnopqrstuvwxyz", "bcdefghijklmnopqrstuvwxyz", "efghijklmnopqrstuvwxyz"]
null

3
27000
["cdefghijklmnopqrstuvwxyz", "lmnopqrstuvwxyz", "bcdefghijklmnopqrstuvwxyz", "efghijklmnopqrstuvwxyz"]
"efghijklmnopqrstuvwxyz"

2
27000
["cdefghijklmnopqrstuvwxyz", "lmnopqrstuvwxyz", "bcdefghijklmnopqrstuvwxyz", "efghijklmnopqrstuvwxyz"]
"bcdefghijklmnopqrstuvwxyz"

1
27000
["cdefghijklmnopqrstuvwxyz", "lmnopqrstuvwxyz", "bcdefghijklmnopqrstuvwxyz", "efghijklmnopqrstuvwxyz"]
"lmnopqrstuvwxyz"

0
27000
["cdefghijklmnopqrstuvwxyz", "lmnopqrstuvwxyz", "bcdefghijklmnopqrstuvwxyz", "efghijklmnopqrstuvwxyz"]
"cdefghijklmnopqrstuvwxyz"

7
28000
["cdefghijklmnopqrstuvwxyz", "jklmnopqrst", "bcdefghijklmnopqrstuvwxyz"]
null

6
28000
["cdefghijklmnopqrstuvwxyz", "jklmnopqrst", "bcdefghijklmnopqrstuvwxyz"]
null

5
28000
["cdefghijklmnopqrstuvwxyz", "jklmnopqrst", "bcdefghijklmnopqrstuvwxyz"]
null

4
28000
["cdefghijklmnopqrstuvwxyz", "jklmnopqrst", "bcdefghijklmnopqrstuvwxyz"]
null

3
28000
["cdefghijklmnopqrstuvwxyz", "jklmnopqrst", "bcdefghijklmnopqrstuvwxyz"]
null

2
28000
["cdefghijklmnopqrstuvwxyz", "jklmnopqrst", "bcdefghijklmnopqrstuvwxyz"]
"bcdefghijklmnopqrstuvwxyz"

1
28000
["cdefghijklmnopqrstuvwxyz", "jklmnopqrst", "bcdefghijklmnopqrstuvwxyz"]
"jklmnopqrst"

0
28000
["cdefghijklmnopqrstuvwxyz", "jklmnopqrst", "bcdefghijklmnopqrstuvwxyz"]
"cdefghijklmnopqrstuvwxyz"

7
29000
["defghijklmnopqrstuvwxyz", "jklmnopqrstuvwxyz", "efghijklmnopqrstuvwxyz"]
null

6
29000
["defghijklmnopqrstuvwxyz", "jklmnopqrstuvwxyz", "efghijklmnopqrstuvwxyz"]
null

5
29000
["defghijklmnopqrstuvwxyz", "jklmnopqrstuvwxyz", "efghijklmnopqrstuvwxyz"]
null

4
29000
["defghijklmnopqrstuvwxyz", "jklmnopqrstuvwxyz", "efghijklmnopqrstuvwxyz"]
null

3
29000
["defghijklmnopqrstuvwxyz", "jklmnopqrstuvwxyz", "efghijklmnopqrstuvwxyz"]
null

2
29000
["defghijklmnopqrstuvwxyz", "jklmnopqrstuvwxyz", "efghijklmnopqrstuvwxyz"]
"efghijklmnopqrstuvwxyz"

1
29000
["defghijklmnopqrstuvwxyz", "jklmnopqrstuvwxyz", "efghijklmnopqrstuvwxyz"]
"jklmnopqrstuvwxyz"

0
29000
["defghijklmnopqrstuvwxyz", "jklmnopqrstuvwxyz", "efghijklmnopqrstuvwxyz"]
"defghijklmnopqrstuvwxyz"


SELECT CONCAT(tagsVal,' [', COUNT(tagsVal),' Items available for this tag]') AS tag FROM
(WITH RECURSIVE tblrows AS(
SELECT 0 AS rnum, MAX((LENGTH(t)-LENGTH(REPLACE(t,',',''))) +1) AS maxtags
FROM
(SELECT Item, JSON_UNQUOTE(tags) AS t FROM mytable) A UNION ALL
SELECT rnum+1, maxtags FROM tblrows WHERE rnum+1 <= maxtags)
SELECT rnum, item, JSON_UNQUOTE(tags),
       JSON_EXTRACT(tags, CONCAT('$[', rnum, ']')) AS tagsVal
FROM
    tblrows t CROSS JOIN mytable m
 ) sq1
 WHERE tagsVal IS NOT NULL
 GROUP BY tagsVal





tag


"fghijklmnopqrstuvwxyz" [3 Items available for this tag]

"efghijklmnopqrstuvwxyz" [12 Items available for this tag]

"klmnopqrstuvwxyz" [11 Items available for this tag]

"cdefghijklmnopqrstuvwxyz" [9 Items available for this tag]

"ghijklmnopqrstuvwxyz" [6 Items available for this tag]

"abcdefghijklmnopqrstuvwxyz" [8 Items available for this tag]

"bcdefghijklmnopqrstuvwxyz" [4 Items available for this tag]

"fghij" [1 Items available for this tag]

"cd" [1 Items available for this tag]

"defghijklmnopqrstuvwxyz" [4 Items available for this tag]

"ijklmnopqrs" [1 Items available for this tag]

"hijklmnopqrstuvwxyz" [5 Items available for this tag]

"ghijklmnopqrstu" [1 Items available for this tag]

"jklmnopqrstuvwxyz" [8 Items available for this tag]

"ijklmnopqrstuvwxyz" [6 Items available for this tag]

"efghijklmnopqrstuvw" [1 Items available for this tag]

"lmnopqrstuvwxyz" [4 Items available for this tag]

"defghijklmno" [1 Items available for this tag]

"efg" [1 Items available for this tag]

"fghijklmnopqrstuv" [1 Items available for this tag]

"ijkl" [1 Items available for this tag]

"ghijklmnopqrstuvw" [1 Items available for this tag]

"hijklmnopqrst" [1 Items available for this tag]

"defghij" [1 Items available for this tag]

"bcdefghijklm" [1 Items available for this tag]

"fghijklmnopq" [1 Items available for this tag]

"jklmnopqrs" [1 Items available for this tag]

"cdefghijklmnopq" [1 Items available for this tag]

"bcdefghijklmnopqrstuvw" [1 Items available for this tag]

"klmnop" [1 Items available for this tag]

"jklmnopqrst" [1 Items available for this tag]