Search
 
SCRIPT & CODE EXAMPLE
 

SQL

mongodb not in

#all documents whose country field value is not neither Portugal or Spain
query = db.collection.find({
    "country" : { '$nin': [
        'Portugal',
        'Spain']
    }
})
Comment

not in in mongodb

-- Syntax: { field: { $nin: [ <value1>, <value2> ... <valueN> ] } }
db.inventory.find( { quantity: { $nin: [ 5, 15 ] } }, { _id: 0 } )
Comment

PREVIOUS NEXT
Code Example
Sql :: SQL UNIQUE Constraint 
Sql :: Join multiple table by MySQL 
Sql :: while mysql 
Sql :: min and max salary and name in sql 
Sql :: How to automatically export database to a csv file 
Sql :: SQL JOIN and Aliases 
Sql :: selecting all columns from table sql database 
Sql :: Should I use the datetime or timestamp data type in MySQL? 
Sql :: store date time in mysql 
Sql :: group by sql 
Sql :: select * from 
Sql :: create table if not exist 
Sql :: sqlite output query to csv 
Sql :: nested query 
Sql :: how to join result table in mysql 
Sql :: sql query to linq converter online 
Sql :: apex run 404 
Sql :: mssql xml 
Sql :: grant privileges mysql to database 1064 
Sql :: sql select all 
Sql :: sql shell psql cannot enter password 
Sql :: sort by 
Sql :: Windows internal database connection 
Sql :: mysql add 24 hours to datetime 
Sql :: executescalar in sql server 
Sql :: mysql Puede ser solamente un campo automatico y este debe ser definido como una clave 
Sql :: NLS_NCHAR_CHARACTERSET 
Sql :: what is unsigned mysql 
Sql :: oracle_home sqlplus 
Sql :: postgresql using reserved word as column name 
ADD CONTENT
Topic
Content
Source link
Name
9+1 =