Doctrine ODM - like operator syntax

Question

how would i go about simulating the like operator from SQL in doctrine odm?

use case: i want to find a Theme that has somewhere in the field caption string in a variable $search.

How would the query look like?

thanks for all answers

Answer 1

For me, this worked:

use MongoDB\BSON\Regex;

$qb->field($field)->equals(new Regex($searchTerm));

Probably just dependencies are newer.

Answer 2

use MongoRegex

$qb->field($field)->equals(new \MongoRegex('/.*paliw.*/i'));

source

But i recomed use separate search engine (sphinx, Solr)