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 offers
(
  id int,
  deleted_at datetime,
  ean varchar(100),
  net_price int
);
insert into offers (id, ean, net_price) 
values (1, '123', 1), (2, '123', 2), (3, '123', 3), (4, '456', 4);  
UPDATE offers t1
SET t1.deleted_at = NOW()
WHERE t1.id 
    NOT IN
    (
        SELECT f.id
        FROM (
        SELECT ean, MIN(net_price) as minprice
        FROM offers group BY ean
        ) 
        as x inner join (select * from offers) as f on f.ean = x.ean and f.net_price = x.minprice
    );
select * from offers;


id
deleted_at
ean
net_price


1
null
123
1

2
2021-07-12 06:30:37
123
2

3
2021-07-12 06:30:37
123
3

4
null
456
4


update offers set deleted_at = null;
UPDATE offers
SET deleted_at = NOW()
WHERE (ean, net_price) NOT IN
(
  SELECT ean, MIN(net_price)
  FROM (select * from offers) o
  GROUP BY ean
);
select * from offers;


id
deleted_at
ean
net_price


1
null
123
1

2
2021-07-12 06:30:37
123
2

3
2021-07-12 06:30:37
123
3

4
null
456
4


update offers set deleted_at = null;
UPDATE offers t1
SET t1.deleted_at = NOW()
WHERE EXISTS
(
  SELECT NULL
  FROM (SELECT * FROM offers) t2
  WHERE t2.ean = t1.ean
  AND t2.net_price < t1.net_price
);
select * from offers;


id
deleted_at
ean
net_price


1
null
123
1

2
2021-07-12 06:30:37
123
2

3
2021-07-12 06:30:37
123
3

4
null
456
4

id	deleted_at	ean	net_price
1	null	123	1
2	2021-07-12 06:30:37	123	2
3	2021-07-12 06:30:37	123	3
4	null	456	4