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 vote373 views1 answer
Create table in dbms cmds
SQL
20 votes384 views4 answers
How to find average in sql
SQL
6 votes345 views2 answers
Postgresql restore from dump
SQL
0 vote347 views1 answer
Wincc 7.4 to sql stackoverflow
SQL
5 votes356 views1 answer
Sysdate in oracle sql
SQL
3 votes324 views3 answers
How to set up an auto incrementing id db browser
SQL
1 vote321 views1 answer
Increase date by one day in sql oracle
SQL
1 vote311 views1 answer
Foreign key constraint in ms sql
SQL
2 votes331 views1 answer
Sql column values comma separated
SQL
0 vote340 views2 answers
Jsonb
SQL