MySQL學習必備條件查詢資料

2022-03-25 13:02:23

一、條件查詢

利用where語句可以對資料進行篩選

select * from 表名 where 條件;

select * from users where id = 1;

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

select * from users where not id = 1;

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

select * from users where id between 1 and 5;

注：null與''是不一樣的

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

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

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

select * from users where birth_date is null;

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

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

到此這篇關於MySQL學習必備條件查詢資料的文章就介紹到這了,更多相關MySQL條件查詢資料內容請搜尋it145.com以前的文章或繼續瀏覽下面的相關文章希望大家以後多多支援it145.com！