By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE `Report` (
`Id` int(11) DEFAULT NULL,
`Monday` text,
`Tuesday` text,
`Wednesday` text,
`Thursday` text,
`Friday` text,
`Saturday` text,
`Sunday` text
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
INSERT INTO `Report`
(`Id`,
`Monday`,
`Tuesday`,
`Wednesday`,
`Thursday`,
`Friday`,
`Saturday`,
`Sunday`)
VALUES
(2,
'ALL',
'ALL',
'ALL',
'ALL',
'ALL',
NULL,
NULL);
INSERT INTO `Report`
(`Id`,
`Monday`,
| id | Count |
|---|---|
| 2 | 5 |
| 1 | 5 |