The AND/OR operators are used to create an SQL statement based on 2 or more conditions in SQL WHERE clause. They can be used in SELECT, UPDATE, DELETE or INSERT statement.

The AND operator selects records if all the conditions in WHERE clause are true at the same time. The OR operator selects records if any conditions in the WHERE clause are true.

Read more