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 vote141 views1 answer
Multiple count in sql
SQL
0 vote139 views1 answer
Mariadb cast null to 0
SQL
0 vote171 views1 answer
Fetching data from mysqldb
SQL
0 vote166 views1 answer
Sql date with year
SQL
0 vote134 views1 answer
How to make case insensitive in sql
SQL
0 vote159 views1 answer
Mysql find the row ites of the hoghest value at on column
SQL
0 vote143 views1 answer
#1231 - Variable 'sql_mode' can't be set to the value of 'NULL'
SQL
0 vote147 views1 answer
Get who is hired in february in sql
SQL
0 vote140 views1 answer
Initcap in mysql
SQL
0 vote129 views2 answers
Raise notice in postgresql function
SQL