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 vote179 views1 answer
Sqlite3 now
SQL
2 votes245 views3 answers
Mysql kill
SQL
11 votes194 views2 answers
MySQL DISTINCT
SQL
0 vote181 views1 answer
Check index sql server
SQL
0 vote233 views2 answers
Create more than 1 tables with references to each other in sqlite3
SQL
16 votes196 views6 answers
Install sqlite3 python
SQL
6 votes288 views3 answers
POSTGRES INSERT INTO TABLE VALUE FROM OTHER TABLE
SQL
0 vote233 views1 answer
Create-table-with-index-organization
SQL
0 vote236 views1 answer
Mysql enter ubuntu
SQL
-1 vote284 views5 answers
Left join
SQL