The MySQL AND condition is used with SELECT, INSERT, UPDATE or DELETE statements to test two or more conditions in an individual query.
condition1, condition2, … condition_n: Specifies all conditions that must be fulfilled for the records to be selected.
MySQL AND Example
The following example specifies how to use the AND condition in MySQL with SELECT statement.
Consider a table “cus_tbl”, having the following data:
Execute the following query: