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

22 votes342 views3 answers
SQL CHEATSHEET
SQL
0 vote329 views1 answer
Sql insert tuple
SQL
0 vote348 views1 answer
Sql select upcoming birthdays
SQL
0 vote324 views1 answer
Postgres declare variable
SQL
1 vote318 views1 answer
Set mysql mode global query
SQL
16 votes344 views1 answer
Mysql smallint range
SQL
0 vote384 views1 answer
Install mysql on bash
SQL
3 votes428 views1 answer
Oracle cannot access v$session
SQL
0 vote326 views1 answer
Mysql change timestamp on update
SQL
19 votes339 views5 answers
Date between in mysql
SQL