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

1 vote182 views2 answers
Create table if not exist
SQL
1 vote160 views1 answer
Oracle convert run duration to number
SQL
0 vote172 views1 answer
Cannot create a JSON value from a string with CHARACTER SET 'binary'.
SQL
12 votes164 views1 answer
Create column sql server
SQL
1 vote168 views1 answer
Incompatible sql_mode=only_full_group_by
SQL
-1 vote185 views1 answer
Pl sql drop trigger
SQL
0 vote179 views2 answers
How to create a table from another table in sql derby
SQL
0 vote166 views1 answer
Postgresql default value boolean
SQL
23 votes198 views5 answers
Sql substring
SQL
6 votes153 views1 answer
Phpmyadmin reset root password
SQL