SQL转MongoDB查询语法

示例查询（点击使用）
基本查询 SELECT * FROM users WHERE age > 18
多条件查?/strong> SELECT * FROM users WHERE age >= 18 AND status = 'active' AND city = 'Beijing'
OR条件 SELECT * FROM users WHERE status = 'active' OR role = 'admin'
IN查询 SELECT * FROM products WHERE category IN ('electronics', 'books', 'clothing')
LIKE查询 SELECT * FROM users WHERE name LIKE '%john%'
排序和分?/strong> SELECT name, email FROM users WHERE active = 1 ORDER BY created_at DESC LIMIT 10 OFFSET 20
NULL检?/strong> SELECT * FROM orders WHERE shipped_at IS NULL
NOT NULL检?/strong> SELECT * FROM orders WHERE shipped_at IS NOT NULL
BETWEEN查询 SELECT * FROM products WHERE price BETWEEN 100 AND 500
COUNT聚合 SELECT COUNT(*) FROM users WHERE status = 'active'
GROUP BY聚合 SELECT city, COUNT(*) as count FROM users GROUP BY city
NOT IN查询 SELECT * FROM users WHERE role NOT IN ('guest', 'banned')
SQL到MongoDB对照?/summary>
SQL MongoDB
WHERE a = 1 { a: 1 }
WHERE a != 1 { a: { $ne: 1 } }
WHERE a > 1 { a: { $gt: 1 } }
WHERE a >= 1 { a: { $gte: 1 } }
WHERE a < 1 { a: { $lt: 1 } }
WHERE a <= 1 { a: { $lte: 1 } }
WHERE a IN (1,2,3) { a: { $in: [1,2,3] } }
WHERE a NOT IN (1,2,3) { a: { $nin: [1,2,3] } }
WHERE a LIKE '%text%' { a: /text/ }
WHERE a LIKE 'text%' { a: /^text/ }
WHERE a LIKE '%text' { a: /text$/ }
WHERE a IS NULL { a: null }
WHERE a IS NOT NULL { a: { $ne: null } }
WHERE a AND b { $and: [{a}, {b}] }
WHERE a OR b { $or: [{a}, {b}] }
ORDER BY a ASC .sort({ a: 1 })
ORDER BY a DESC .sort({ a: -1 })
LIMIT n .limit(n)
OFFSET n .skip(n)
SELECT a, b .project({ a: 1, b: 1 })
COUNT(*) .countDocuments()