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 vote212 views1 answer
Convert epoch to date in sql server
SQL
0 vote195 views1 answer
Grepper sql workbench download
SQL
2 votes203 views1 answer
Drop table if exists in postgres
SQL
0 vote204 views2 answers
Mysql dump database tables only
SQL
3 votes184 views1 answer
Postgresql if null then 0
SQL
19 votes261 views4 answers
Can't connect to local MySQL server through socket '/tmp/mysql.sock'
SQL
0 vote189 views1 answer
Using GROUP BY in MySQL Join Table
SQL
0 vote207 views1 answer
Postgresql not in alternative
SQL
0 vote200 views3 answers
Sql server import json
SQL
16 votes267 views4 answers
Find duplicates mysql
SQL