Database.Guide

Skip to content

Beginners

  • What is a Database?
  • Database Tutorial

SQL

  • SQL Tutorial
  • SQL Reference
  • SQL Joins Tutorial
  • SQL Transactions Tutorial
  • Basic SQL Queries

Categories

  • Azure SQL Edge (17)
  • Database Concepts (99)
  • Database Tools (72)
  • DBMS (9)
  • DuckDB (125)
  • MariaDB (424)
  • Microsoft Access (17)
  • MongoDB (265)
  • MySQL (602)
  • NoSQL (8)
  • Oracle (301)
  • PostgreSQL (480)
  • Redis (210)
  • SQL (697)
  • SQL Server (1,169)
  • SQLite (298)

Category: DBMS

Database Management Systems

MongoDB $isNumber

Posted on February 5, 2021February 5, 2021 by Ian

From MongoDB 4.4, you can use the $isNumber aggregation pipeline operator to check whether or not a value is a number.

It accepts any valid expression, and returns true if the expression is a number, false if it’s not.

Continue reading →
MongoDB aggregation, data types, operators, what is

MongoDB $replaceAll

Posted on February 5, 2021February 5, 2021 by Ian

The $replaceAll aggregation pipeline operator was introduced in MongoDB 4.4.

This operator replaces all instances of a search string in an input string with a replacement string and returns the result.

If the search string isn’t found, then $replaceAll returns the input string.

Continue reading →
MongoDB aggregation, operators, what is

MongoDB $replaceOne

Posted on February 5, 2021February 5, 2021 by Ian

The $replaceOne aggregation pipeline operator was introduced in MongoDB 4.4.

This operator replaces the first instance of a search string in an input string with a replacement string and returns the result.

If the search string isn’t found, then $replaceOne returns the input string.

Continue reading →
MongoDB aggregation, operators, what is

MongoDB $last Aggregation Pipeline Operator

Posted on February 4, 2021February 4, 2021 by Ian

MongoDB 4.4 introduced the $last aggregation pipeline operator.

This operator returns the last element in an array.

Continue reading →
MongoDB aggregation, operators, what is

MongoDB $first Aggregation Pipeline Operator

Posted on February 4, 2021February 4, 2021 by Ian

MongoDB 4.4 introduced the $first aggregation pipeline operator.

This operator returns the first element in an array.

Continue reading →
MongoDB aggregation, operators, what is

MongoDB $arrayElemAt

Posted on February 4, 2021April 28, 2024 by Ian

In MongoDB, the $arrayElemAt aggregation pipeline operator returns the element at the specified array index.

It accepts two arguments;

  • The array
  • The index of the element you want to retrieve
Continue reading →
MongoDB aggregation, arrays, operators, what is

MongoDB $bsonSize

Posted on February 3, 2021February 3, 2021 by Ian

From MongoDB 4.4, you can use the $bsonSize aggregation pipeline operator to return the size of a given document in bytes.

$bsonSize accepts any valid expression as long as it resolves to either an object or null. 

Continue reading →
MongoDB aggregation, operators, what is

MongoDB Object.bsonSize()

Posted on February 3, 2021February 3, 2021 by Ian

In MongoDB, you can use the Object.bsonSize() method to return the size of a document in bytes.

Continue reading →
MongoDB methods, what is

MongoDB $binarySize

Posted on February 3, 2021February 3, 2021 by Ian

From MongoDB 4.4, you can use the $binarySize aggregation pipeline operator to return the size of a given string or binary data value’s content in bytes.

It accepts any valid expression as long as it resolves to either a string or binary data value. The argument can also be null, in which case, $binarySize returns null.

Continue reading →
MongoDB aggregation, operators, what is

MongoDB $type Query Operator

Posted on February 2, 2021February 2, 2021 by Ian

In MongoDB, you can use the $type element query operator to filter a collection of documents based on BSON type. It returns just those documents that have a particular BSON type in a specific field.

You provide the field and the BSON type, and $type will return all documents that match.

Continue reading →
MongoDB data types, operators, what is
  • «
  • 1
  • …
  • 231
  • 232
  • 233
  • 234
  • 235
  • …
  • 366
  • »

About Database.Guide | Privacy Policy