What is the equivalent command in MongoDB for the following SQL query?SELECT * FROM posts WHERE author like "%john%" Options: A . &nbspdb.posts.find( { author: /john/ } ) B . &nbspdb.posts.find( { author: {$like: /john/} } ) C . &nbspdb.posts.find( { $like: {author: /john/} } ) D . &nbspdb.posts.find( { author: /^john^/ } )

What is the equivalent command in MongoDB for the following SQL query?SELECT *

Question

What is the equivalent command in MongoDB for the following SQL query?SELECT * FROM posts WHERE author like "%john%"

Options:

A . db.posts.find( { author: /john/ } )

B . db.posts.find( { author: {$like: /john/} } )

C . db.posts.find( { $like: {author: /john/} } )

D . db.posts.find( { author: /^john^/ } )

Answer: Option A

Submit Your Solution Below and Earn Points !

Next Question

Question 1. Which field is always the first field in the document....

Question 2. What is the interactive shell for MongoDB called?....

Question 3. Command display the list of databases....

Question 4. Which of the following line skips the first 5 documents in the bios collection and returns all remaining documents?....

Question 5. Which of the following is used to start server in MongoDB?....

Question 6. MongoDB is a _________ database that provides high performance, high availability, and easy scalability....

Question 7. MongoDB Queries can return specific fields of documents which also include user-defined __________ functions....

Question 8. Which of the following method is used to query documents in collections?....

Question 9. A collection in MongoDB is a group of ....

Question 10. Which of the following operation adds a new document to the users collection ?....

Chapter 1 - GLOBAL STEEL SCENARIO & INDIAN STEEL INDUSTRY Part 1 : (13-04-2024) INDUSTRY AND COMPANY AWARENESS (ICA)

Direction Sense Test Part 1 Reasoning (Hindi)

Chapter 1 - RMHP / OHP / OB & BP Part 1 : (14-02-2024) GPOE

Cube & Cuboid Part 1 Reasoning (Hindi)

Data Interpretation (DI) Basic Concept Reasoning (Hindi)

Counting Figures Part 1 Counting Of Straight Lines Reasoning (Hindi)

Sail E0 free webinar Webinars

Real Numbers Part 7 Class 10 Maths

Real Numbers Part 1 Class 10 Maths

Polynomials Part 1 Class 10 Maths

Pie Chart - Test Paper 1 Data Interpretation Reasoning & DI

Tabulation - Test Paper 2 Data Interpretation Reasoning & DI

Test Paper 1 Direction Sense Test Reasoning & DI

ICA , RDIC,GFM Free Modal Test Paper - Non - Technical Branch Old Syllabus 2022 - SAIL Junior Officer E0

GFM Combined 1 Free Revision Test SAIL JO E-0