# LikeConditionBuilder

> Class LikeConditionBuilder builds objects of yii\db\conditions\LikeCondition

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

| class | `yii\db\conditions\LikeConditionBuilder` |
| --- | --- |
| 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/conditions/LikeConditionBuilder.php`](https://github.com/yiisoft/yii2/blob/22.0/framework/db/conditions/LikeConditionBuilder.php#L22) |

3 subclasses:

- [`yii\db\mssql\conditions\LikeConditionBuilder`](/docs/api/yii/db/mssql/conditions/likeconditionbuilder/index.md)
- [`yii\db\oci\conditions\LikeConditionBuilder`](/docs/api/yii/db/oci/conditions/likeconditionbuilder/index.md)
- [`yii\db\sqlite\conditions\LikeConditionBuilder`](/docs/api/yii/db/sqlite/conditions/likeconditionbuilder/index.md)

Class LikeConditionBuilder builds objects of [`LikeCondition`](/docs/api/yii/db/conditions/likecondition/index.md)

## Properties

| Property | Type | Description | Defined by |
| --- | --- | --- | --- |
| [`$escapeCharacter`](#property-escapeCharacter) protected | `string\|null` | Character used to escape special characters in LIKE conditions. Default: `null`. | `LikeConditionBuilder` |
| [`$escapingReplacements`](#property-escapingReplacements) protected | `array` | Map of chars to their replacements in LIKE conditions. Default: `['%' => '\%', '_' => '\_', '\\' => '\\\\']`. | `LikeConditionBuilder` |
| <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) |
| [`build()`](#method-build) | Method builds the raw SQL from the $expression that will not be additionally escaped or quoted. | `LikeConditionBuilder` |
| [`parseOperator()`](#method-parseOperator) protected |  | `LikeConditionBuilder` |

## Property details

### $escapeCharacter <span id="property-escapeCharacter"></span>

```php
protected string|null $escapeCharacter = null
```

Character used to escape special characters in LIKE conditions.

By default it's assumed to be `\`.

### $escapingReplacements <span id="property-escapingReplacements"></span>

```php
protected array $escapingReplacements = ['%' => '\%', '_' => '\_', '\\' => '\\\\']
```

Map of chars to their replacements in LIKE conditions.

By default it's configured to escape `%`, `_` and `\` with `\`.

## Method details

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

```php
public function build(yii\db\ExpressionInterface|yii\db\conditions\LikeCondition $expression, array &$params = []): string
```

Method builds the raw SQL from the $expression that will not be additionally
escaped or quoted.

**Parameters**

| Parameter | Type | Description |
| --- | --- | --- |
| `$expression` | [`yii\db\ExpressionInterface`](/docs/api/yii/db/expressioninterface/index.md)`\|`[`LikeCondition`](/docs/api/yii/db/conditions/likecondition/index.md) | The expression to be built. |
| `$params` | `array` | The binding parameters. |

**Returns**

`string`: The raw SQL that will not be additionally escaped or quoted.

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

```php
protected function parseOperator(string $operator): array
```

**Parameters**

| Parameter | Type | Description |
| --- | --- | --- |
| `$operator` | `string` |  |

**Returns**

`array`