MySQL AND

In MySQL the Logical operator AND returns true only if the expressions linked by it evaluates to true. If we are using the AND operator in the WHERE clause, then the query will return only those rows for which all the conditions specified in the WHERE clause evaluates to true. …