MySQL AND Condition
MySQL AND condition used with SELECT, INSERT, UPDATE or DELETE statements to test two or more conditions in an individual query.
MySQL AND Syntax
WHERE condition1 AND condition2 ... AND condition_n;
MySQL AND Example
SELECT * FROM students WHERE mark <= 70 AND mark >= 50; ... AND condition_n;