1
2.. include:: ../../Includes.txt
3
4=================================================
5Feature: #47812 - Query support for BETWEEN added
6=================================================
7
8See :issue:`47812`
9
10Description
11===========
12
13Support for `between` has been added to the Extbase `Query` object. As there is no performance
14advantage to using BETWEEN on the DBMS side (the optimizer converts it to `(min <= expr AND expr <= max)`
15this function replicates the DBMS behaviour by building a logical AND condition that has the advantage
16of working on all DBMS.
17
18Example:
19
20.. code-block:: php
21
22	$query->matching(
23		$query->between('uid', 3, 5)
24	);
25
26
27.. index:: PHP-API, ext:extbase
28