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

7 votes101 views1 answer
Oracle set sequence value to max(id)
SQL
0 vote93 views1 answer
Mysql last 6 months
SQL
2 votes121 views1 answer
Oracle trace file
SQL
1 vote106 views1 answer
Join to find results not in another table
SQL
1 vote132 views2 answers
How to add amount between date in sql
SQL
0 vote53 views1 answer
Oracle sql developer script output limit
SQL
0 vote92 views1 answer
Tsql generate rows
SQL
0 vote115 views1 answer
Mysql get date diff in months
SQL
-1 vote138 views1 answer
Mysql faster insert
SQL
0 vote108 views1 answer
Sqlite löschen einer tabelle
SQL