在一个sql查询中计算很多布尔字段？

SELECT * FROM table_name WHERE column1 = 'value1' OR column2 = 'value2' OR column3 = 'value3';

SELECT * FROM table_name WHERE column1 = 'value1' OR column2 IN ('value2', 'value3');

SELECT * FROM table_name WHERE column1 = 'value1' OR column2 = 'value2' OR column3 IN ('value3', 'value4');

SELECT * FROM table_name WHERE CONCAT_WS(',', column1, column2, column3) LIKE '%value1,%value2,%value3%';

SELECT * FROM table_name WHERE column1 IN (SELECT column2 FROM another_table WHERE column3 = 'value3');

SELECT * FROM table_name WHERE CASE
    WHEN column1 = 'value1' AND column2 = 'value2' THEN 'value3'
    WHEN column1 = 'value4' AND column2 = 'value5' THEN 'value6'
    ELSE 'default'
END = 'value3';

SELECT * FROM table_name1
JOIN table_name2 ON table_name1.column_name = table_name2.column_name
WHERE table_name1.column_name = 'value1' OR table_name2.column_name = 'value2';

SELECT column1, COUNT(*) as count FROM table_name GROUP BY column1 HAVING count > 2;