mongodb的通配符查询的一次失败经验
我想find到mongo中的synonym_titles下面的嵌套子json下的影片名字段或者real_titles下面的嵌套子json下的影片名字段：
创新互联长期为1000+客户提供的网站建设服务，团队从业经验10年，关注不同地域、不同群体，并针对不同对象提供差异化的产品和服务；打造开放共赢平台，与合作伙伴共同营造健康的互联网生态环境。为滨海新区企业提供专业的成都网站建设、成都做网站，滨海新区网站改版等技术服务。拥有10余年丰富建站经验和众多成功案例,为您定制开发。
但是1,2这个info信息字段不确定
所以我想这么查询：
db.search_correct_synonym.find({"synonym_titles.*":"联邦调查局"})
但是失败了，这种查询是告诉mongo，我想找到无论哪一个field，只要包含value=联邦调查局的field
最后的办法，想要找到指定的片名，可以把这些片名copy出来放到一个独立的field里，比如all_titles:["联邦调查局", "帅哥在一九二五"]，可以对该字段建索引。
这样就能根据db.search_correct_synonym.find({"all_titles":"联邦调查局"})找到了
详见http://stackoverflow.com/questions/6179871/MongoDB-wildcard-in-the-key-of-a-query
As asked, this is not possible. The server issue you linked to is still under"issues we're not sure of".
MongoDB has some intelligence surrounding the use of arrays, and I think that's part of the complexity surrounding such a feature.
Take the following querydb.foo.find({ 'a.b' : 4 } ). This query will match the following documents.
{ a: { b: 4 } }{ a: [ { b: 4 } ] }
So what does "wildcard" do here?db.foo.find( { a.* : 4 } )Does it match the first document? What about the second?
Moreover, what does this mean semantically? As you've described, the query is effectively"find documents where any field in that document has a value of 4". That's a little unusual.
Is there a specific semantic that you're trying to achieve? Maybe a change in the document structure will get you the query you want.
|
|
|
| thanks, that clarifies. More specifically, what I'm looking to do is wildcard just the specific node in the branch, i.e. any proper subfield of a. I'm not clear on how a.* says 'find where any field'. Isn't it 'find documents that have a top-level field 'a' with a subfield that matches 4'? – BradJun 1 '11 at 5:48 |
| I think the confusion here is around "subfield". When I write{a:{b:4,c:2}}, I am saying that the valueais a JSON object. That JSON object has two keysbandc. The value of those keys are 4 & 2 respectively. When you are asking fora.*, you're effectively asking for syntax that loops through all of the keys in that JSON object. Your're not asking to"loop through an array", you're asking to"loop through an object's properties". That's a little unusual, which is why I'm asking for a specific use case here. – Gates VPJun 1 '11 at 17:15 |
| @gates: I have a use case. myDocInMongo = {'someUnknownKey':{propToCheck:true}, 'someKnownKey':true}; Now, I want to find this document using the selector {someKnownKey:{$exists:true}} but i also want to make sure that none of the other keys have an object with the property propToCheck. So, like the following: {'*.propToCheck':{$exists:false}, {someKnownKey:{$exists:true}}} – doubletapMay 3 '12 at 17:57 |
|
文章名称：mongodb的通配符查询的一次失败经验
文章源于：
http://ybzwz.com/article/pggdph.html
