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

1 vote144 views1 answer
Pv mysql import
SQL
0 vote186 views1 answer
Mysql extract day from date leading zero
SQL
0 vote205 views2 answers
Mysql cast to varchar
SQL
-1 vote173 views1 answer
SQL SERVER microsoft How to Add Column at Specific Location in Table
SQL
12 votes159 views5 answers
Sql primary key
SQL
0 vote147 views1 answer
How to export only procedures mysql
SQL
0 vote148 views1 answer
Sql replace id with name from another table
SQL
9 votes147 views2 answers
Nosql databases
SQL
17 votes154 views3 answers
Postgresql version command
SQL
1 vote155 views2 answers
Reset mysqli fetch_arra
SQL