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 vote169 views1 answer
See Foreign Key
SQL
0 vote169 views1 answer
How to fetch unique records from two tables
SQL
0 vote176 views1 answer
Sql decode
SQL
0 vote210 views1 answer
Best sql collation
SQL
0 vote214 views1 answer
SQL joins in python
SQL
1 vote182 views1 answer
How to run parallel queries in sql server with entity framework
SQL
1 vote182 views1 answer
Sql first
SQL
0 vote166 views1 answer
Mysql query to check record exists in database table or not
SQL
0 vote167 views1 answer
SQL authentication error
SQL
20 votes170 views4 answers
Sqlite create table if not exists
SQL