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 vote258 views1 answer
Postgresql log
SQL
0 vote312 views2 answers
Sql unique
SQL
0 vote270 views1 answer
Set Mamp mysql globally
SQL
5 votes273 views1 answer
Oracle list days between two dates
SQL
2 votes261 views1 answer
Get hour from date sql
SQL
7 votes240 views2 answers
Create index mysql
SQL
4 votes254 views1 answer
Check database name postgresql
SQL
0 vote266 views1 answer
Create table with float datatype in sql server
SQL
0 vote260 views1 answer
Sql search all columns of database oracle sql
SQL
6 votes279 views2 answers
Postgresql restore from dump
SQL