mysql where 数值范围_MySQL WHERE 筛选数据

语法

SELECT

field1,

field2

FROM

table_name

WHERE

field1 = value1 [AND|OR] field2 = value2

运算符支持 =、!=、<>、>、=、<=、<=> 、IN、LINK、REGEXP

逻辑操作支持 AND、OR 且 AND 优先级大于 OR

例子

//结构

CREATE TABLE `user` (

`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,

`name` varchar(10) NOT NULL,

`age` tinyint(4) NOT NULL,

`sex` tinyint(4) NOT NULL,

`tel` char(11) NOT NULL,

PRIMARY KEY (`id`)

)ENGINE=InnoDB DEFAULT CHARACTER SET utf8;

//单条件查询

SELECT * FROM `user` WHERE `id` = 1;

//AND查询

SELECT * FROM `user` WHERE `name` = '张三' AND `sex` = 1;

//OR查询

SELECT * FROM `user` WHERE `name`