⭐
🍌
☁️
✨
‹ 返回课程
条件筛选
编程代码 · SQL 数据库
💡 SQL 条件筛选：比较、范围、模糊匹配、枚举
SELECT * FROM users WHERE age >= 18;↵// WHERE age >= 18 筛选年龄大于等于 18 的用户
SELECT * FROM orders WHERE status = 'paid';↵// = 'paid' 精确匹配状态为已付款的订单
SELECT name FROM students WHERE score BETWEEN 80 AND 100;↵// BETWEEN 80 AND 100 范围筛选（含两端）
SELECT * FROM products WHERE name LIKE '%phone%';↵// LIKE '%phone%' 模糊匹配包含 phone 的商品名
SELECT * FROM users WHERE city IN ('Beijing', 'Shanghai');// IN (...) 匹配多个指定值
0 字/分0% 准确
🐵
S左手无名指
ESC 暂停⌫ 退格