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

2 votes145 views2 answers
TSQL GET ALL COLUMNS IN TABLE
SQL
2 votes147 views1 answer
SQLSTATE[HY000] [1049] Unknown database
SQL
5 votes150 views1 answer
Com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Public Key Retrieval is not allowed
SQL
6 votes140 views3 answers
Mysql server is not starting xampp
SQL
28 votes207 views6 answers
Foreign key
SQL
1 vote169 views1 answer
Oracle select row max date
SQL
0 vote134 views1 answer
Edit a field mysql terminal
SQL
0 vote173 views1 answer
Time data type in mysql
SQL
16 votes139 views2 answers
Add column to all tables after first column mysql
SQL
16 votes151 views3 answers
Update table from another table
SQL