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 votes390 views1 answer
Where clause for child record apex
SQL
0 vote353 views1 answer
Sql pad left 0
SQL
0 vote398 views1 answer
Oracle sql developer closed connection
SQL
0 vote406 views1 answer
Sql to excel pgadmin
SQL
3 votes387 views4 answers
Truncate syntax in sql
SQL
0 vote340 views1 answer
Dapper run sql script with parameters
SQL
1 vote345 views1 answer
Mysql sort by date column
SQL
0 vote360 views1 answer
Https://livesql.oracle.com/apex/livesql/s/l8fedwph53gt5gigbacwvu6m0
SQL
0 vote290 views1 answer
Sql table to store status
SQL
1 vote346 views1 answer
How to select rows with no matching entry in another table?
SQL