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

0 vote217 views1 answer
Get clob size oracle
SQL
0 vote215 views1 answer
Wincc 7.4 to sql stackoverflow
SQL
0 vote195 views2 answers
Update all linkedserver tables with openquery on db
SQL
1 vote159 views1 answer
Strict in postgres SQL
SQL
0 vote217 views2 answers
Port 5432 is already in use mac
SQL
0 vote196 views1 answer
Mysql date time string format for marshmellow field schema
SQL
2 votes210 views1 answer
Sql server: select column values as comma separated string
SQL
5 votes224 views1 answer
How to get all table names in sql query
SQL
0 vote193 views1 answer
Update top 100 sql
SQL
0 vote196 views1 answer
Oracle archivemode
SQL