By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table online_plan (
id integer primary key,
squad integer,
status varchar(10),
date varchar(10)
);
insert into online_plan values(1, 10, 'closed', '15.12.2019')
SELECT *
FROM online_plan
WHERE
STR_TO_DATE(date, '%d.%m.%Y') >= CURDATE()
AND squad = '10'
AND status !='opened'