MySQL 8.0

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

select version();


version()


8.0.25


create table tab (id int, name varchar(20), color varchar(20), price int, status int);
insert into tab values (2, 'Samsung S9', 'White', 24000000, 1),
                       (3, 'Oppo F5', 'Red', 7000000, 1),
                       (5, 'MSI GT 900', 'Black', 12000000, 1),
                       (12, 'Iphone 11 Pro Max', 'Green', 1800000, 1),
                       (13, 'Nokia 6300', 'Blue', 1100000, 1),
                       (14, 'IPad Mini', 'White', 2000000, 1),                       
                       (4, 'Macbook', 'Grey', 5000000, 1);
select * from tab;


id
name
color
price
status


2
Samsung S9
White
24000000
1

3
Oppo F5
Red
7000000
1

5
MSI GT 900
Black
12000000
1

12
Iphone 11 Pro Max
Green
1800000
1

13
Nokia 6300
Blue
1100000
1

14
IPad Mini
White
2000000
1

4
Macbook
Grey
5000000
1


SET @j = '[2, 4, 5, 14]'
SELECT * FROM JSON_TABLE(@j, "$[*]" COLUMNS(Value INT PATH "$")) data;


Value


2

4

5

14


SET @k = '{"id": [2, 4, 5, 14] }'
SELECT * FROM JSON_TABLE(@k, "$.id[*]" COLUMNS(Value INT PATH "$")) data;


Value


2

4

5

14


SET @l = '{"outer": [{"id": 2} , {"id": 4}, {"id": 5}, {"id": 14}] }'
SELECT * FROM JSON_TABLE(@l, "$.outer[*]" COLUMNS(Value INT PATH "$.id")) data;


Value


2

4

5

14


UPDATE tab 
   SET status = 0
 WHERE id in (SELECT * FROM JSON_TABLE(@j, "$[*]" COLUMNS(Value INT PATH "$")) data);
select * from tab;


id
name
color
price
status


2
Samsung S9
White
24000000
0

3
Oppo F5
Red
7000000
1

5
MSI GT 900
Black
12000000
0

12
Iphone 11 Pro Max
Green
1800000
1

13
Nokia 6300
Blue
1100000
1

14
IPad Mini
White
2000000
0

4
Macbook
Grey
5000000
0

id	name	color	price	status
2	Samsung S9	White	24000000	1
3	Oppo F5	Red	7000000	1
5	MSI GT 900	Black	12000000	1
12	Iphone 11 Pro Max	Green	1800000	1
13	Nokia 6300	Blue	1100000	1
14	IPad Mini	White	2000000	1
4	Macbook	Grey	5000000	1