0

Final Class Yiisoft\Db\Mssql\Builder\LikeBuilder

All Classes | Properties | Methods
InheritanceYiisoft\Db\Mssql\Builder\LikeBuilder » Yiisoft\Db\QueryBuilder\Condition\Builder\LikeBuilder

Build an object of {@see LikeCondition} into SQL expressions for MSSQL Server.

Protected Properties

Hide inherited properties

Property Type Description Defined By
$escapingReplacements array Map of chars to their replacements in LIKE conditions. Yiisoft\Db\Mssql\Builder\LikeBuilder

Public Methods

Hide inherited methods

Method Description Defined By
build() Yiisoft\Db\Mssql\Builder\LikeBuilder

Property Details

Hide inherited properties

$escapingReplacements protected property

Map of chars to their replacements in LIKE conditions. By default, it's configured to escape %, _, [ with ], \\.

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

Method Details

Hide inherited methods

build() public method

public string build ( \Yiisoft\Db\Expression\ExpressionInterface $expression, array &$params = [] )
$expression \Yiisoft\Db\Expression\ExpressionInterface
$params array 

                public function build(ExpressionInterface $expression, array &$params = []): string
{
    if ($expression->caseSensitive === true) {
        throw new NotSupportedException('MSSQL doesn\'t support case-sensitive "LIKE" conditions.');
    }
    return parent::build($expression, $params);
}