# Operators

### Comparison Operators

| MySQL  | MongoDB |
| ------ | ------- |
| =      | $eq     |
| <>     | $ne     |
| >      | $gt     |
| <      | $lt     |
| >=     | $gte    |
| <=     | $lte    |
| in     | $in     |
| not in | $nin    |

**Example**

```
//

db.friendsCollection.find(
    {"lastname":{$nin:["Geller","Green"]}}
)

// 

db.friendsCollection.find(
    {"lastname":{$nin:["Geller","Green"]}}
).count()
```

### **Logical Operators**

| MySQL | MongoDB |
| ----- | ------- |
| and   | $and    |
| or    | $or     |
| not   | $not    |
|       |         |