MySQL 5.7

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

select version();


version()


5.7.39


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;

Records: 7  Duplicates: 0  Warnings: 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


SET @j = '[2, 4, 5, 14]'
SELECT JSON_CONTAINS(@j, '2', '$');


JSON_CONTAINS(@j, '2', '$')


1


SET @k = '{"id": [2, 4, 5, 14] }'
SELECT JSON_CONTAINS(@k, '2', '$.id');


JSON_CONTAINS(@k, '2', '$.id')


1


UPDATE tab 
   SET status = 0
 WHERE JSON_CONTAINS(@j, CAST(id as CHAR(20)), '$');

Rows matched: 4  Changed: 4  Warnings: 0


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