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 vote209 views1 answer
Column ' ' in field list is ambiguous
SQL
0 vote278 views1 answer
Mengatasi error mysqldump: [ERROR] unknown option '--no-beep'
SQL
3 votes201 views1 answer
Laravel database Using Named Bindings
SQL
0 vote242 views1 answer
Table structure in sql
SQL
0 vote225 views1 answer
How to add unique key constraint in mysql
SQL
0 vote191 views1 answer
Date datatype in livesql
SQL
5 votes200 views3 answers
Mysql extract month from date
SQL
1 vote197 views1 answer
DATE_SUB postgres
SQL
11 votes211 views1 answer
Sql insert multiple rows from select
SQL
19 votes195 views4 answers
Rename database in sql
SQL