文、意如
在資料中是否有此值?
WHERE 欄位 IN (“值1”,”值2”)
SELECT *
FROM `grade`
WHERE name IN ("JJJ","QQQ")
在資料中排除值
WHERE 欄位 NOT IN (“值1”,”值2”)
SELECT * FROM `grade` WHERE name NOT IN ("JJJ","QQQ");
Yiru@Studio - 關於我 - 意如
2022-12-17
MySql-語法練習2-查詢練習-在資料中是否有此值,或排除此資料?(WHERE IN 、WHERE NOT IN)