MySQL AND Operator

The AND operator is a logical operator that combines two or more Boolean expressions and returns true only if both expressions evaluate to true. The AND operator returns false if one of the two expressions evaluate to false.

Here is the syntax of the AND operator:

SELECT 
    customername, 
    country, 
    state
FROM
    customers
WHERE
    country = 'USA' AND state = 'CA';

Source: mysqltutorial.org

Similar codes

8 votes228 views1 answer
Database backup in mysql server recovery
SQL
-1 vote180 views1 answer
Mac mysql workbench console
SQL
-1 vote196 views2 answers
Mysql error 1064 you have an error in your sql syntax
SQL
0 vote253 views1 answer
How to get number of months between 2 dates sql server
SQL
1 vote191 views1 answer
Psql view enum values
SQL
0 vote202 views1 answer
Desinstaller mysql sur ubuntu definitivement
SQL
1 vote180 views2 answers
Sql server add time to date
SQL
2 votes183 views1 answer
Q operator in sql
SQL
0 vote186 views1 answer
Mysql a from on this page has
SQL
0 vote187 views1 answer
Failed to process SQL command - ORA-28014: cannot drop administrative user or role
SQL