How can I use regular expressions with Doctrine's Mongodb ODM?

php mongodb doctrine doctrine-odm
chaostheory picture chaostheory · Jun 4, 2012 · Viewed 8.3k times · Source

I'm trying to use regular expressions to query Mongodb using Doctrine's Mongodb ODM on Symfony 2.

I know the PHP mongo driver can do it. However, I don't know how to do this with Doctrine.

Do I use the same class? How do I reference MongoRegex from within Symfony?

Answer

jmikola picture jmikola · Jun 4, 2012

This came up a while ago on the doctrine-user mailing list. You can use the \MongoRegex class directly in your ODM queries:

$documentRepository->findBy(array(
    'foo' => new \MongoRegex('/^bar/'),
));

Or if using a query builder:

$queryBuilder->field('foo')->equals(new \MongoRegex('/^bar/'));

Keep in mind that front-anchored, case-sensitive regex patterns will be able to use indexes most efficiently. This is discussed in more detail in the Mongo docs.

Related questions

Installing the PHP 7 MongoDB Client/Driver?

I am very eager to start working with PHP 7 however one issue is getting in the way... I primarily use MongoDB for the database, and the problem is that I don't know how to install the MongoDB driver/client for …

Read More
Class 'MongoClient' not found

I'm trying to make this code run: <?php $m = new MongoClient("mongodb://54.72.237.242"); $db = $m->tilbud; ?> Everytime I got the same error: Fatal error: Class 'MongoClient' not found in C:\xampp\htdocs\conexion.php I've been reading about …

Read More
MongoDB and CodeIgniter

Can anyone assist in pointing me to a tutorial, library, etc. that will allow me to work with MongoDB from CodeIgniter?

Read More