MySQL 8.0

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

CREATE TABLE `AAA` (
   `c` BOOLEAN NULL DEFAULT NULL,
   `des` Text 
);
 
INSERT INTO `AAA` (`c`, `des`) VALUES (NULL,'1');
INSERT INTO `AAA` (`c`, `des`) VALUES (NULL,'1');
INSERT INTO `AAA` (`c`, `des`) VALUES (NULL,'1');
INSERT INTO `AAA` (`c`, `des`) VALUES (NULL,'2');
INSERT INTO `AAA` (`c`, `des`) VALUES (NULL,'2');
INSERT INTO `AAA` (`c`, `des`) VALUES (TRUE, '2');

SELECT * FROM `AAA`;


c
des


null
1

null
1

null
1

null
2

null
2

1
2


-- CASE 1 : 取出 `des` = '2' 而且 `c` 只要含有 TRUE 就是為 TRUE
SELECT  
CASE WHEN 
SUM(CASE WHEN `c`=TRUE THEN 1 ELSE 0 END) >=1 
THEN 'TRUE' ELSE 'FALSE' END AS ored_C,des
FROM `AAA` WHERE `des` = '2' 
GROUP BY des;


ored_C
des


TRUE
2


-- CASE 2 : 取出 `des` = '2' 而且 `c` 不含有 FALSE 就是為 TRUE
SELECT  
CASE WHEN 
SUM(CASE WHEN `c`=TRUE OR `c` IS NULL THEN 0 ELSE 1 END) >=1 
THEN 'FALSE' ELSE 'TRUE' END AS ored_C,des
FROM `AAA` WHERE `des` = '2' 
GROUP BY des;


ored_C
des


TRUE
2

c	des
null	1
null	1
null	1
null	2
null	2
1	2