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

Seismology

Answer 1

use MongoRegex

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

source

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

Acanthous

ok, this works. now i want to search the same variable in other field. i tried adding $qb->field('name')->equals(new \MongoRegex('/.*'.$this->search.'.*/i')); but i get empty results. how to do this? – Seismology