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 votes130 views2 answers
Sql query to copy data from one column to another
SQL
0 vote146 views1 answer
Cube oracle
SQL
2 votes137 views1 answer
Sql skip the first row
SQL
5 votes156 views3 answers
Sql limit offset
SQL
2 votes119 views1 answer
Check isolation level in mysql
SQL
8 votes118 views3 answers
Alter table auto_increment
SQL
2 votes118 views1 answer
Oracle calculated column
SQL
0 vote147 views2 answers
Suse stop MySQL
SQL
0 vote123 views1 answer
Sql change date format
SQL
0 vote126 views1 answer
Cartesian product sql
SQL