# yii\db\conditions

> 20 classes, 1 interface of the yii\db\conditions namespace.

[API reference](/docs/api/index.md) › [yii](/docs/api/yii/index.md) › [db](/docs/api/yii/db/index.md) › conditions

## Classes

| Class | Summary |
| --- | --- |
| [`AndCondition`](/docs/api/yii/db/conditions/andcondition/index.md) | Condition that connects two or more SQL expressions with the `AND` operator. |
| [`BetweenColumnsCondition`](/docs/api/yii/db/conditions/betweencolumnscondition/index.md) | Class BetweenColumnCondition represents a `BETWEEN` condition where values is between two columns. For example: |
| [`BetweenColumnsConditionBuilder`](/docs/api/yii/db/conditions/betweencolumnsconditionbuilder/index.md) | Class BetweenColumnsConditionBuilder builds objects of [`BetweenColumnsCondition`](/docs/api/yii/db/conditions/betweencolumnscondition/index.md) |
| [`BetweenCondition`](/docs/api/yii/db/conditions/betweencondition/index.md) | Class BetweenCondition represents a `BETWEEN` condition. |
| [`BetweenConditionBuilder`](/docs/api/yii/db/conditions/betweenconditionbuilder/index.md) | Class BetweenConditionBuilder builds objects of [`BetweenCondition`](/docs/api/yii/db/conditions/betweencondition/index.md) |
| [`ConjunctionCondition`](/docs/api/yii/db/conditions/conjunctioncondition/index.md) abstract | Class ConjunctionCondition |
| [`ConjunctionConditionBuilder`](/docs/api/yii/db/conditions/conjunctionconditionbuilder/index.md) | Class ConjunctionConditionBuilder builds objects of abstract class [`ConjunctionCondition`](/docs/api/yii/db/conditions/conjunctioncondition/index.md) |
| [`ExistsCondition`](/docs/api/yii/db/conditions/existscondition/index.md) | Condition that represents `EXISTS` operator. |
| [`ExistsConditionBuilder`](/docs/api/yii/db/conditions/existsconditionbuilder/index.md) | Class ExistsConditionBuilder builds objects of [`ExistsCondition`](/docs/api/yii/db/conditions/existscondition/index.md) |
| [`HashCondition`](/docs/api/yii/db/conditions/hashcondition/index.md) | Condition based on column-value pairs. |
| [`HashConditionBuilder`](/docs/api/yii/db/conditions/hashconditionbuilder/index.md) | Class HashConditionBuilder builds objects of [`HashCondition`](/docs/api/yii/db/conditions/hashcondition/index.md) |
| [`InCondition`](/docs/api/yii/db/conditions/incondition/index.md) | Represents `IN` condition. |
| [`InConditionBuilder`](/docs/api/yii/db/conditions/inconditionbuilder/index.md) | Builds objects of [`InCondition`](/docs/api/yii/db/conditions/incondition/index.md). |
| [`LikeCondition`](/docs/api/yii/db/conditions/likecondition/index.md) | Class LikeCondition represents a `LIKE` condition. |
| [`LikeConditionBuilder`](/docs/api/yii/db/conditions/likeconditionbuilder/index.md) | Class LikeConditionBuilder builds objects of [`LikeCondition`](/docs/api/yii/db/conditions/likecondition/index.md) |
| [`NotCondition`](/docs/api/yii/db/conditions/notcondition/index.md) | Condition that inverts passed `condition`. |
| [`NotConditionBuilder`](/docs/api/yii/db/conditions/notconditionbuilder/index.md) | Class NotConditionBuilder builds objects of [`NotCondition`](/docs/api/yii/db/conditions/notcondition/index.md) |
| [`OrCondition`](/docs/api/yii/db/conditions/orcondition/index.md) | Condition that connects two or more SQL expressions with the `AND` operator. |
| [`SimpleCondition`](/docs/api/yii/db/conditions/simplecondition/index.md) | Class SimpleCondition represents a simple condition like `"column" operator value`. |
| [`SimpleConditionBuilder`](/docs/api/yii/db/conditions/simpleconditionbuilder/index.md) | Class NotConditionBuilder builds objects of [`SimpleCondition`](/docs/api/yii/db/conditions/simplecondition/index.md) |

## Interfaces

| Interface | Summary |
| --- | --- |
| [`ConditionInterface`](/docs/api/yii/db/conditions/conditioninterface/index.md) | Interface ConditionInterface should be implemented by classes that represent a condition in DBAL of framework. |