# InConditionBuilder

> Builds objects of yii\db\conditions\InCondition.

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

| class | `yii\db\sqlite\conditions\InConditionBuilder` |
| --- | --- |
| Extends | [`yii\db\conditions\InConditionBuilder`](/docs/api/yii/db/conditions/inconditionbuilder/index.md) |
| Implements | [`yii\db\ExpressionBuilderInterface`](/docs/api/yii/db/expressionbuilderinterface/index.md) |
| Uses traits | [`yii\db\ExpressionBuilderTrait`](/docs/api/yii/db/expressionbuildertrait/index.md) |
| Since | 2.0.14 |
| Source | [`framework/db/sqlite/conditions/InConditionBuilder.php`](https://github.com/yiisoft/yii2/blob/22.0/framework/db/sqlite/conditions/InConditionBuilder.php#L25) |

Builds objects of [`InCondition`](/docs/api/yii/db/conditions/incondition/index.md).

## Properties

| Property | Type | Description | Defined by |
| --- | --- | --- | --- |
| <span id="property-queryBuilder"></span>[`$queryBuilder`](/docs/api/yii/db/expressionbuildertrait/index.md#property-queryBuilder) protected | [`yii\db\QueryBuilder`](/docs/api/yii/db/querybuilder/index.md) | Default: `null`. | [`yii\db\ExpressionBuilderTrait`](/docs/api/yii/db/expressionbuildertrait/index.md) |

## Methods

| Method | Description | Defined by |
| --- | --- | --- |
| <span id="method-__construct"></span>[`__construct()`](/docs/api/yii/db/expressionbuildertrait/index.md#method-__construct) | ExpressionBuilderTrait constructor. | [`yii\db\ExpressionBuilderTrait`](/docs/api/yii/db/expressionbuildertrait/index.md) |
| <span id="method-build"></span>[`build()`](/docs/api/yii/db/conditions/inconditionbuilder/index.md#method-build) | Builds raw SQL from the expression. | [`yii\db\conditions\InConditionBuilder`](/docs/api/yii/db/conditions/inconditionbuilder/index.md) |
| <span id="method-buildCompositeInCondition"></span>[`buildCompositeInCondition()`](/docs/api/yii/db/conditions/inconditionbuilder/index.md#method-buildCompositeInCondition) protected | Builds SQL for composite IN condition. | [`yii\db\conditions\InConditionBuilder`](/docs/api/yii/db/conditions/inconditionbuilder/index.md) |
| [`buildSubqueryInCondition()`](#method-buildSubqueryInCondition) protected | Builds SQL for IN condition. | `InConditionBuilder` |
| <span id="method-buildValues"></span>[`buildValues()`](/docs/api/yii/db/conditions/inconditionbuilder/index.md#method-buildValues) protected | Builds values to be used in [`InCondition`](/docs/api/yii/db/conditions/incondition/index.md). | [`yii\db\conditions\InConditionBuilder`](/docs/api/yii/db/conditions/inconditionbuilder/index.md) |
| [`getNotEqualOperator()`](#method-getNotEqualOperator) protected | Returns inequality operator for decomposed `NOT IN` conditions. | `InConditionBuilder` |
| <span id="method-getNullCondition"></span>[`getNullCondition()`](/docs/api/yii/db/conditions/inconditionbuilder/index.md#method-getNullCondition) protected | Builds `IS NULL` / `IS NOT NULL` condition for a scalar column based on the operator. | [`yii\db\conditions\InConditionBuilder`](/docs/api/yii/db/conditions/inconditionbuilder/index.md) |

## Method details

### buildSubqueryInCondition() <span id="method-buildSubqueryInCondition"></span>

```php
protected function buildSubqueryInCondition(string $operator, array|string|yii\db\ExpressionInterface $columns, yii\db\Query $values, array &$params): string
```

Builds SQL for IN condition.

**Parameters**

| Parameter | Type | Description |
| --- | --- | --- |
| `$operator` | `string` | Operator in uppercase. |
| `$columns` | `array\|string\|`[`yii\db\ExpressionInterface`](/docs/api/yii/db/expressioninterface/index.md) | The columns to be matched. |
| `$values` | [`yii\db\Query`](/docs/api/yii/db/query/index.md) | Subquery values. |
| `$params` | `array` | The binding parameters. |

**Returns**

`string`: SQL for IN condition.

**Throws**

- [`yii\base\NotSupportedException`](/docs/api/yii/base/notsupportedexception/index.md): if `$columns` is an array

### getNotEqualOperator() <span id="method-getNotEqualOperator"></span>

```php
protected function getNotEqualOperator(): string
```

Returns inequality operator for decomposed `NOT IN` conditions.

**Returns**

`string`: Inequality operator.