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

18 votes105 views4 answers
Foreign key mySql
SQL
0 vote104 views2 answers
What is the library that should import to use all functional database features in SQLite?
SQL
0 vote112 views1 answer
Dump db only triggers mysql
SQL
1 vote104 views1 answer
Error code 1055
SQL
0 vote107 views1 answer
Sql change date format
SQL
0 vote108 views1 answer
Add multiple field in table sql
SQL
3 votes114 views2 answers
Check data in table mysql
SQL
1 vote109 views1 answer
Convert rows to string sql server
SQL
0 vote107 views1 answer
Restore backupfile discourse
SQL
0 vote119 views1 answer
Select nth row in mysql
SQL