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 (128)
  • 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)

Tag: operators

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 $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

MongoDB $type Aggregation Pipeline Operator

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

In MongoDB, the $type aggregation pipeline operator returns the BSON type of its argument.

You can use it to find out the type of a given field.

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

MongoDB $toObjectId

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

From MongoDB 4.0, you can use the $toObjectId aggregation pipeline operator to convert a string to an ObjectId.

The string must be a hexadecimal string of length 24.

Continue reading →
MongoDB aggregation, convert, operators, what is

MongoDB $rtrim

Posted on February 1, 2021February 1, 2021 by Ian

In MongoDB, the $rtrim aggregation pipeline operator removes whitespace from the end of a string. This includes the null character.

It can also remove any character specified. For example, you could use it to remove all periods (.), exclamation marks (!), etc from the end of a string.

Continue reading →
MongoDB aggregation, operators, what is

MongoDB $ltrim

Posted on February 1, 2021February 1, 2021 by Ian

In MongoDB, the $ltrim aggregation pipeline operator removes whitespace from the beginning of a string. This includes the null character.

It can also remove any character specified. For example, you could use it to remove all hyphen characters (-) from the beginning of a string.

Continue reading →
MongoDB aggregation, operators, what is

MongoDB $trim

Posted on February 1, 2021February 1, 2021 by Ian

In MongoDB, the $trim aggregation pipeline operator removes whitespace from the beginning and end of a string. This includes the null character.

It can also remove any character specified. For example, you could use it to remove all hyphen characters (-) or periods (.) or all s characters, etc.

Continue reading →
MongoDB aggregation, operators, what is

MongoDB $toLong

Posted on January 31, 2021January 31, 2021 by Ian

From MongoDB 4.0, you can use the $toLong aggregation pipeline operator to convert a value to a long.

Continue reading →
MongoDB aggregation, convert, operators, what is

MongoDB $toInt

Posted on January 31, 2021January 31, 2021 by Ian

From MongoDB 4.0, you can use the $toInt aggregation pipeline operator to convert a value to an integer.

Continue reading →
MongoDB aggregation, convert, operators, what is
  • «
  • 1
  • …
  • 16
  • 17
  • 18
  • 19
  • 20
  • …
  • 22
  • »

About Database.Guide | Privacy Policy