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

2 votes143 views1 answer
Oracle current date without time
SQL
0 vote182 views1 answer
Oracle enable chain
SQL
1 vote207 views1 answer
Dropping a constraint in ms sql
SQL
3 votes189 views1 answer
V$session not found in oracle
SQL
0 vote197 views1 answer
Get the Domain Name, Page Name and Query Parameter from a URL
SQL
0 vote201 views1 answer
Varchar2 length in oracle
SQL
7 votes192 views1 answer
Sql server management studio turn on line numbers
SQL
0 vote245 views1 answer
Redshift running queries
SQL
-1 vote154 views1 answer
How to create script to connect to oracle database and run query
SQL
0 vote189 views1 answer
Kotlin sqlite delete row
SQL