When using multiple conditions in a SQL query, what is the difference between "AND" and "OR" operators?

When using multiple conditions in a SQL query, the "AND" operator is used to retrieve rows that meet all of the specified conditions, while the "OR" operator is used to retrieve rows that meet at least one of the specified conditions. It is important to use parentheses to clarify the order of operations when combining "AND" and "OR" operators in a SQL query.

$query = "SELECT * FROM table_name WHERE condition1 AND (condition2 OR condition3)";