在 Mongodb 中组合两个字段搜索 [英] search in combination two field in Mongodb

问题描述

我使用 Mongodb 和我的数据库架构，如下所示:

I use from Mongodb and my database schema like this:

firstName: 'vahid',
lastName: 'kh',
age: 12 

我想找到所有名字+姓氏喜欢'vahid kh'的记录.在 SQL 中，这将是:

I want find all records that firstname + lastname likes 'vahid kh'. In SQL, this would be:

Select * from table where firstName + lastName like '%vahid kh%'

Select * from table where firstName + lastName like '%vahid kh%'

推荐答案

似乎这仅在今天发布的 2.4 中可用.

Seems this is available only in 2.4, which was released today.

> db.temp.save({ "firstName" : "Bob", "lastName" : "Smith", Age : 12 });
> db.temp.find();
{ "_id" : ObjectId("5148a2a00477cddcdece1b34"), "firstName" : "Bob", "lastName" : "Smith", "Age" : 12 }
> db.temp.aggregate({ $project : { "name" : { $concat : [ "$firstName", " ", "$lastName" ] } } });
{
    "result" : [
       {
           "_id" : ObjectId("5148a2a00477cddcdece1b34"),
           "name" : "Bob Smith"
       }
    ],
    "ok" : 1
} 

这篇关于在 Mongodb 中组合两个字段搜索的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！