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 vote320 views1 answer
SQL add a totals of differemt rows of the same id
SQL
0 vote276 views1 answer
Mysql convert column to uppercase
SQL
0 vote323 views1 answer
Regex mongoose
SQL
6 votes313 views1 answer
Allsource oracle
SQL
1 vote315 views1 answer
Mysql get character set
SQL
0 vote322 views2 answers
Sql max count
SQL
0 vote351 views1 answer
Python sql passer des parametres dans une requet pymysql
SQL
1 vote330 views1 answer
Get all db sizes in mysql server
SQL
0 vote318 views1 answer
Set column width in sqlplus
SQL
0 vote309 views1 answer
Oracle select invalid views
SQL