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 vote285 views1 answer
Sql get count without group by
SQL
2 votes285 views2 answers
How to check database username and password in postgresql
SQL
0 vote265 views1 answer
Minus equivalent in my sql
SQL
0 vote288 views1 answer
How to list function in psql
SQL
0 vote296 views1 answer
Sqlalchemy one column of two has to be not null
SQL
0 vote278 views1 answer
Openquery insert into linked server
SQL
1 vote289 views1 answer
Hackerrank sql test solutions
SQL
11 votes294 views1 answer
Oracle view source
SQL
0 vote269 views1 answer
Sql query to select records entered in last 24 hours
SQL
3 votes276 views1 answer
Select table column in sql
SQL