[PR #6397] This should fix Criteria startsWith and endsWith #9968

New Issue

admin · 2026-01-22T16:06:01+01:00

admin commented

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

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

State: closed
Merged: No

using like this:

$criteria = Criteria::create();
//$criteria->andWhere(Criteria::expr()->contains("appName", 'a'));
$criteria->andWhere(Criteria::expr()->startsWith("group", 'doct'));
$repository->matching($criteria);

# before
SELECT ... FROM app_data t0 WHERE t0.`group`
# after
SELECT ... FROM app_data t0 WHERE t0.`group` LIKE ?

and exception if more than one expression:

An exception occurred while executing 'SELECT ... FROM app_data t0 WHERE (t0.appName LIKE ? AND t0.group )' with params ["%a%", "doct"]:

SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens

**Original Pull Request:** https://github.com/doctrine/orm/pull/6397 **State:** closed **Merged:** No --- using like this: ```php $criteria = Criteria::create(); //$criteria->andWhere(Criteria::expr()->contains("appName", 'a')); $criteria->andWhere(Criteria::expr()->startsWith("group", 'doct')); $repository->matching($criteria); ``` ```sql # before SELECT ... FROM app_data t0 WHERE t0.`group` # after SELECT ... FROM app_data t0 WHERE t0.`group` LIKE ? ``` and exception if more than one expression: > An exception occurred while executing 'SELECT ... FROM app_data t0 WHERE (t0.appName LIKE ? AND t0.`group` )' with params ["%a%", "doct"]: > > SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens

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

admin closed this issue

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

admin referenced this issue

2026-01-22 16:12:37 +01:00

[PR #9968] Stabilize the DBAL dependency #12011

Sign in to join this conversation.