MySQL 5.7

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

create table products (
 id int primary key, 
 purchase_date varchar(10)
);
insert into products values
  (1, '2019-02-02')
, (2, '2019-02-01')
, (3, '2019-02-03')
DELETE FROM products
WHERE YEAR(purchase_date) = 2019
ORDER BY purchase_date DESC
LIMIT 1;
select * from products


id
purchase_date


1
2019-02-02

2
2019-02-01