Articles → MONGODB → $Concat Aggregation Operator In MongoDB

$Concat Aggregation Operator In MongoDB

This article describes the $concat aggregation operator in MongoDB.

Purpose

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

Consider the following collection: -

We need to concatenate the firstname and lastname fields. So, the query would be: -

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

Query/Feedback