[mongodb-dev] how to convert mysql queries to mongodb?

[arpit bhatt]

how can i get the result of this mysql query with mongodb?

SELECT * FROM mars_india.user where DATE(creation_date) between
'2015-11-03' and '2015-11-04';

[Ivan Artemov]

http://www.querymongo.com/

Post by arpit bhatt
how can i get the result of this mysql query with mongodb?
SELECT * FROM mars_india.user where DATE(creation_date) between
'2015-11-03' and '2015-11-04';

[gaurav.gupta via mongodb-dev]

Hi Arpit,

Please note that the mongodb-dev
<https://groups.google.com/forum/#!forum/mongodb-dev> mailing list is for
MongoDB development topics only. If you need to ask general questions,
please go to the mongodb-user
<https://groups.google.com/forum/#!forum/mongodb-user> google group.

For querying results within a range of date/value from mongodb collection,
you need to use db.collection.find()
<https://docs.mongodb.com/manual/reference/method/db.collection.find/>
method with query criterias
<https://docs.mongodb.com/manual/reference/method/db.collection.find/#examples>
.
I have formulated this query, assuming ‘creation_date’ is of datatye *date*
<https://docs.mongodb.com/manual/reference/bson-types/#date>, to match your
given MySQL example :

db.user.find({ creation_date :{ $gt : new ISODate("2018-01-31"), $lt : new ISODate("2018-02-24")}}).pretty()

You should also refer to Mongo Shell Methods
<https://docs.mongodb.com/manual/reference/method/#collection> for more
in-depth information on other MongoDB query language operators.

As for http://www.querymongo.com/, it may contain deprecated/removed
MongoDB method as its not up-to-date.
Please refer to db.collection.find()
<https://docs.mongodb.com/manual/reference/method/db.collection.find/#db.collection.find>
and db.collection.aggregate()
<https://docs.mongodb.com/manual/reference/method/db.collection.aggregate/>
or a more up-to-date query or aggregation methods.

Regards,
Gaurav
​

['Bryan Reinero' via mongodb-dev]

Arpit,

You should check out the MongoDB BI Connector, which sits between your SQL
client and your MongoDB deployment, translating incoming MySQL queries into
aggregation pipelines and returning the results back as a relation. Here's
a link https://www.mongodb.com/products/bi-connector

Post by arpit bhatt
how can i get the result of this mysql query with mongodb?
SELECT * FROM mars_india.user where DATE(creation_date) between
'2015-11-03' and '2015-11-04';

[David Murphy]

Additionally you might look at slam data as it does this to allow Tableau and MongoDB to talk and its open source compared to BI connector being Enterprise only.

Post by gaurav.gupta via mongodb-dev
Arpit,
You should check out the MongoDB BI Connector, which sits between your SQL client and your MongoDB deployment, translating incoming MySQL queries into aggregation pipelines and returning the results back as a relation. Here's a link https://www.mongodb.com/products/bi-connector
how can i get the result of this mysql query with mongodb?
SELECT * FROM mars_india.user where DATE(creation_date) between '2015-11-03' and '2015-11-04';
--
You received this message because you are subscribed to the Google Groups "mongodb-dev" group.
Visit this group at https://groups.google.com/group/mongodb-dev <https://groups.google.com/group/mongodb-dev>.
To view this discussion on the web visit https://groups.google.com/d/msgid/mongodb-dev/d76d1d98-e1cd-41e4-8b10-99a5e8aba9cd%40googlegroups.com <https://groups.google.com/d/msgid/mongodb-dev/d76d1d98-e1cd-41e4-8b10-99a5e8aba9cd%40googlegroups.com?utm_medium=email&utm_source=footer>.
For more options, visit https://groups.google.com/d/optout <https://groups.google.com/d/optout>.