BOOL_AND

Aggregates boolean values. It returns TRUE if all of the values in the aggregation are true and FALSE if any of them are false ignoring null values.

Parameter	Type	Description
`value`	boolean	The values to combine with `AND`

Returns: boolean

Example

query:

SELECT BOOL_AND(close_value > 43) AS `close value > 43`,
       sales_agent
  FROM sales_pipeline
 WHERE deal_stage = "Won"
 GROUP BY sales_agent

siyeh/sql-crm-example-data Run query Copy code

result:

close value > 43	sales_agent
true	Maureen Marcano
false	Boris Faz
true	Jonathan Berthelot
true	Vicki Laflamme
true	Donn Cantrell
true	Wilburn Farren
true	Cassey Cress
false	Elease Gluck