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

9 votes208 views2 answers
Sql server check table exists
SQL
0 vote181 views1 answer
How to find username and password in oracle 18c
SQL
0 vote182 views1 answer
Restore backupfile discourse
SQL
0 vote181 views1 answer
Check duplicate values plsql
SQL
-1 vote215 views1 answer
Mysql faster insert
SQL
4 votes228 views1 answer
Postgresql create table with index
SQL
0 vote238 views1 answer
Postgresql create table default value timestamp
SQL
0 vote185 views1 answer
Sql query to force the database to be drop
SQL
1 vote240 views1 answer
Psql search table
SQL
0 vote204 views1 answer
Connecting mySQL to STS
SQL