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

4 votes255 views2 answers
Raise errors.NotSupportedError( mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported
SQL
1 vote236 views1 answer
Oracle create_program
SQL
0 vote243 views1 answer
Insert set mysql
SQL
0 vote310 views2 answers
SQL SERVER ORDER BY DATE NULL LAST
SQL
0 vote266 views1 answer
Postgre query date
SQL
0 vote240 views1 answer
Pl/ sql change currency
SQL
4 votes249 views4 answers
Oracle tablespace tables list
SQL
0 vote229 views1 answer
Time mysql w3
SQL
-2 votes249 views2 answers
Union all in sql
SQL
0 vote224 views2 answers
How to see table associated with a schema in sql
SQL