Search
 
SCRIPT & CODE EXAMPLE
 

SQL

case condition in mongodb

-- $switch has the following syntax:

{
   $switch: {
      branches: [
         { case: { $eq: [ 0, 5 ] }, then: "equals" },
         { case: { $gt: [ 0, 5 ] }, then: "greater than" },
         { case: { $lt: [ 0, 5 ] }, then: "less than" }
      ]
   }
}
Comment

PREVIOUS NEXT
Code Example
Sql :: how to update sql server version 
Sql :: SELECT everything from a sql table 
Sql :: how to update values in sql 
Sql :: sql get month 
Sql :: between date in sql server 
Sql :: create postgres table 
Sql :: while in sql server 
Sql :: how to start with sql 
Sql :: isnull in sqlite 
Sql :: coalesce function in sql server 
Sql :: oracle sql developer 
Sql :: sql update multiple tables 
Sql :: operator in sql 
Sql :: trigger sql 
Sql :: sqlyog clear cache query 
Sql :: mssql replace first occurrence 
Sql :: oracle uptime 
Sql :: sqlcmd no headers 
Sql :: query inner join 
Sql :: create table kusto 
Sql :: create directory in sql server 
Sql :: sql revert migration 
Sql :: 0 
Sql :: update multiple rows 
Sql :: mysql max connections exceeded max_connections_per_hour 
Sql :: into in sql 
Sql :: mysql multiple left joins on same table 
Sql :: create and attach user to a postgresql database 
Sql :: mysql begin statement 
Sql :: data types in sql 
ADD CONTENT
Topic
Content
Source link
Name
2+9 =