phpmongodbsql-likedoctrine-odm

Doctrine ODM - like operator syntax

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

Solution

  • use MongoRegex 

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

    source

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