mongo db to sql conversion 1

Question

db.music.find({deleted: {$ne: true}});

the above code is in mongo db

I want to know how to write the equivalent for this in sql

thank you

Cydrick Trudel · Accepted Answer · 2015-12-11 20:32:49Z

1

select * from music where deleted != true;

or, optimized:

select * from music where deleted == false;

Depending on the version of SQL, the false could be 'false', 0 or '0'

Assuming:

You're already on the right database (no need to put use my.db at the beginning of your script)
Your deleted column is of type boolean or bit.

answered Dec 11, 2015 at 20:26

Cydrick Trudel

10.6k8 gold badges45 silver badges69 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

DhruvJoshi · Accepted Answer · 2015-12-11 20:46:45Z

1

Assuming your storing [deleted] as a bit or nullable bit then :

Select * from [music] where [deleted] != 1

But you can't use sql to query MongoDB, you know that right?

DhruvJoshi

17.2k6 gold badges46 silver badges63 bronze badges

answered Dec 11, 2015 at 20:33

GavKilbride

1,56915 silver badges19 bronze badges