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 vote97 views1 answer
Acual month sql
SQL
0 vote99 views2 answers
Oracle sql for each row
SQL
0 vote107 views1 answer
Oracle date winter time
SQL
1 vote122 views2 answers
One to one and one to many relationship
SQL
6 votes93 views1 answer
Rank function in oracle with example
SQL
0 vote106 views1 answer
Alter owner in PostgreSQL
SQL
10 votes98 views2 answers
Sql pagination offset
SQL
2 votes133 views1 answer
Select from array in psql
SQL
16 votes129 views6 answers
Mysql find duplicates in same table
SQL
0 vote102 views1 answer
Select password from user mysql
SQL