.. include:: /Includes.rst.txt

.. _feature-79262:

==============================================================================
Feature: #79262 - Add possibility to create TRIM expression with Doctrine DBAL
==============================================================================

See :issue:`79262`

Description
===========

The possibility to create TRIM expressions using Doctrine DBAL has been integrated.
However, when using this in comparisons, ExpressionBuilder::comparison() has to be
invoked explicitly - otherwise the created TRIM expression would be quoted if e.g.
used with ExpressionBuilder::eq().

.. code-block:: php

    $queryBuilder->expr()->comparison(
        $queryBuilder->expr()->trim($fieldName),
        ExpressionBuilder::EQ,
        $queryBuilder->createNamedParameter('', \PDO::PARAM_STR)
    );

The call to :php:`$queryBuilder->expr()-trim()` can be one of the following:

* :php:`trim('fieldName')`
  results in :sql:`TRIM("tableName"."fieldName")`

* :php:`trim('fieldName', AbstractPlatform::TRIM_LEADING, 'x')`
  results in :sql:`TRIM(LEADING "x" FROM "tableName"."fieldName")`

* :php:`trim('fieldName', AbstractPlatform::TRIM_TRAILING, 'x')`
  results in :sql:`TRIM(TRAILING "x" FROM "tableName"."fieldName")`

* :php:`trim('fieldName', AbstractPlatform::TRIM_BOTH, 'x')`
  results in :sql:`TRIM(BOTH "x" FROM "tableName"."fieldName")`

.. index:: Database, PHP-API