MySQL学习必备条件查询数据

一、条件查询

利用where语句可以对数据进行筛选

select * from 表名 where 条件;

#yyds干货盘点# 06 MySQL条件查询数据_运算符

select * from users where id = 1;

#yyds干货盘点# 06 MySQL条件查询数据_比较运算符_02

select * from users where id = 1 and age = 24;

#yyds干货盘点# 06 MySQL条件查询数据_比较运算符_03

select * from users where not id = 1;

#yyds干货盘点# 06 MySQL条件查询数据_逻辑运算符_04

select * from users where id in (1,3,4);

#yyds干货盘点# 06 MySQL条件查询数据_运算符_05

select * from users where id between 1 and 5;

#yyds干货盘点# 06 MySQL条件查询数据_运算符_06

注：null与''是不一样的

INSERT INTO users (name, birth_date, phone,age)
VALUES ('', '1990-01-01', '13813145213',30);

#yyds干货盘点# 06 MySQL条件查询数据_运算符_07

#yyds干货盘点# 06 MySQL条件查询数据_逻辑运算符_08

INSERT INTO users (name, birth_date, phone,age)
VALUES (null, '1990-01-01', '13813145213',30);

#yyds干货盘点# 06 MySQL条件查询数据_运算符_09

INSERT INTO users (name, birth_date, phone,age)
VALUES ('老张', null, '17813145213',30);

#yyds干货盘点# 06 MySQL条件查询数据_逻辑运算符_10

select * from users where birth_date is null;

#yyds干货盘点# 06 MySQL条件查询数据_逻辑运算符_11

select * from users where name like '王%';

select * from users where name like '%王';