By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE invite_view (
id int primary key auto_increment,
eventname varchar(50),
eventdate date,
accepted TINYINT);
insert into invite_view(eventname, eventdate, accepted)
values ('Event 1', '2022-04-14', NULL);
insert into invite_view(eventname, eventdate, accepted)
values ('Event 2', '2022-04-25', NULL);
insert into invite_view(eventname, eventdate, accepted)
values ('Event 3', '2022-03-28', 0);
insert into invite_view(eventname, eventdate, accepted)
values ('Event 4', '2022-05-03', 0);
insert into invite_view(eventname, eventdate, accepted)
values ('Event 5', '2022-04-14', 1);
insert into invite_view(eventname, eventdate, accepted)
values ('Event 6', '2022-05-01', 1);
SELECT *
FROM invite_view
ORDER BY CASE WHEN accepted IS NULL THEN accepted
ELSE eventdate
END
| id | eventname | eventdate | accepted |
|---|---|---|---|
| 1 | Event 1 | 2022-04-14 | null |
| 2 | Event 2 | 2022-04-25 | null |
| 3 | Event 3 | 2022-03-28 | 0 |
| 5 | Event 5 | 2022-04-14 | 1 |
| 6 | Event 6 | 2022-05-01 | 1 |
| 4 | Event 4 | 2022-05-03 | 0 |