[PR #7184] Add BETWEEN() expr. #10356

New Issue

admin · 2026-01-22T16:07:16+01:00

admin commented

2026-01-22 16:07:16 +01:00

Original Pull Request: https://github.com/doctrine/orm/pull/7184

State: closed
Merged: No

The PullRuest added one BETWEEN class and a new method for NOT BETWEEN.

#6450 here example for this issues

between and function

$queryBuilder
            ->where(
                $queryBuilder->expr()->between('CURRENT_TIMESTAMP()', ':min', ':max')
            )
            ->setParameter('min', '2018-04-10 10:19:37')
            ->setParameter('max', '2018-04-12 10:19:37')
        ;

not between and mysql function
(The mysql function can not use as parameter)

$queryBuilder
            ->where(
                $queryBuilder->expr()->between('CURRENT_TIMESTAMP()', ':min', ':max')
            )
            ->setParameter('min', '2018-04-10 10:19:37')
            ->setParameter('max', '2018-04-12 10:19:37')
        ;

with orX and between

$queryBuilder
            ->where(
                $queryBuilder->expr()->orX(
                    $queryBuilder->expr()->isNull('user.firstName'),
                    $queryBuilder->expr()->between(':val', 1, 10)
                )
            )
            ->setParameter('val', 5)
        ;

**Original Pull Request:** https://github.com/doctrine/orm/pull/7184 **State:** closed **Merged:** No --- The PullRuest added one BETWEEN class and a new method for NOT BETWEEN. #6450 here example for this issues _between and function_ ```php $queryBuilder ->where( $queryBuilder->expr()->between('CURRENT_TIMESTAMP()', ':min', ':max') ) ->setParameter('min', '2018-04-10 10:19:37') ->setParameter('max', '2018-04-12 10:19:37') ; ``` _not between and mysql function_ (The mysql function can not use as parameter) ```php $queryBuilder ->where( $queryBuilder->expr()->between('CURRENT_TIMESTAMP()', ':min', ':max') ) ->setParameter('min', '2018-04-10 10:19:37') ->setParameter('max', '2018-04-12 10:19:37') ; ``` _with orX and between_ ```php $queryBuilder ->where( $queryBuilder->expr()->orX( $queryBuilder->expr()->isNull('user.firstName'), $queryBuilder->expr()->between(':val', 1, 10) ) ) ->setParameter('val', 5) ; ```

admin added the pull-request label 2026-01-22 16:07:16 +01:00

admin closed this issue

2026-01-22 16:07:17 +01:00

Sign in to join this conversation.

Branches Tags

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: doctrine/archived-orm#10356