Doctrine的Mongodb ODM如何使用正则表达式? [英] How can I use regular expressions with Doctrine's Mongodb ODM?
问题描述
我想使用正则表达式来查询Mongodb,使用Doctrine的Mongodb ODM在Symfony 2上。
我知道 PHP mongo驱动可以做到这一点。但是,我不知道如何用Doctrine这样做。我使用同一个类吗?如何在Symfony中引用MongoRegex?
这是一段时间以前在 doctrine-user 邮件列表。您可以直接在ODM查询中使用 \MongoRegex
类:
$ documentRepository-> findBy(array(
'foo'=> new \MongoRegex('/ ^ bar /'),
));
或使用查询构建器:
$ queryBuilder-> field('foo') - > equals(new \MongoRegex('/ ^ bar /'));
请记住,前置,区分大小写的正则表达式模式将能够最有效地使用索引。这在 Mongo docs 中有更详细的讨论。 p>
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?
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.
这篇关于Doctrine的Mongodb ODM如何使用正则表达式?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!