mysql 查询not

SELECT * FROM table_name WHERE column_name NOT IN (value1, value2, ...);

SELECT * FROM table_name t1 WHERE NOT EXISTS (SELECT 1 FROM table_name t2 WHERE t1.column = t2.column);

SELECT * FROM table_name WHERE column_name NOT LIKE 'pattern';

-- 使用 NOT IN
SELECT * FROM students WHERE student_id NOT IN (SELECT student_id FROM exam_records WHERE exam_name = 'Math Exam');

-- 使用 NOT EXISTS
SELECT * FROM students s WHERE NOT EXISTS (SELECT 1 FROM exam_records e WHERE s.student_id = e.student_id AND e.exam_name = 'Math Exam');

-- 使用 NOT LIKE（假设考试名称包含特定模式）
SELECT * FROM students WHERE exam_name NOT LIKE '%Math Exam%';