SQL 转 MongoDB
在线 SQL 转 MongoDB 工具，将 SELECT、WHERE、ORDER BY 等 SQL 查询语句转换为对应的 MongoDB 查询语法（find/filter），一键复制结果，免费且浏览器本地运行不上传。
示例查询（点击使用）
基本查询
SELECT * FROM users WHERE age > 18多条件查询
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%'排序和分页
SELECT name, email FROM users WHERE active = 1 ORDER BY created_at DESC LIMIT 10 OFFSET 20NULL检查
SELECT * FROM orders WHERE shipped_at IS NULLNOT NULL检查
SELECT * FROM orders WHERE shipped_at IS NOT NULLBETWEEN查询
SELECT * FROM products WHERE price BETWEEN 100 AND 500COUNT聚合
SELECT COUNT(*) FROM users WHERE status = 'active'GROUP BY聚合
SELECT city, COUNT(*) as count FROM users GROUP BY cityNOT IN查询
SELECT * FROM users WHERE role NOT IN ('guest', 'banned')SQL到MongoDB对照表
| 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() |