MySQL9

DQL

where条件筛选

# 查看id=12的数据
SELECT * FROM userinfo WHERE userinfo.id = 12

# 取别名
SELECT userinfo.`name` AS '名字' FROM userinfo WHERE userinfo.id=12  # as可以省略

# 模糊查询
SELECT userinfo.`name` FROM userinfo WHERE userinfo.`name` LIKE '%三%'
SELECT userinfo.`name` FROM userinfo WHERE userinfo.`name` LIKE'_三'

# 范围查询
SELECT userinfo.`name` AS '名字' FROM userinfo WHERE userinfo.id BETWEEN 9 AND 12

# 不连续查询
SELECT userinfo.`name` FROM userinfo WHERE id IN(8,10,12)

# 空值查询
SELECT * FROM userinfo WHERE age IS NULL

总结

/*
where支持的运算符
		1、比较运算符
			<,>,>=,<=,=,!=
		2、逻辑运算符
				and or not
		3、模糊查询like
				%代表任意多个  _代表任何一个字符
		4、范围查找 between and 
				where 字段名 between 开始值 and 结束值
		5、不连续查找in，空值查找is
		6、优先级
				小括号>not>比较运算符>逻辑运算符
				and比or先运算，希望or先运算加()			
*/