Articles → MONGODB → $Concat Aggregation Operator In Mongodb

$Concat Aggregation Operator In Mongodb

In this article, we will discuss the $concat aggregation operator in MongoDB.

Purpose

The $concat operator concatenates the strings and returns the concatenated string.

Consider the following collection: -

We are required to concatenate the firstname and lastname field. So, the query would be: -

db.Employees.aggregate([
  {
    $project: {
      fullName: { $concat: ["$firstname", " ", "$lastname"] }
    }
  }
])

Query/Feedback