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 vote154 views1 answer
Sql server kill all connections
SQL
3 votes171 views2 answers
Find string in stored procedure sql server
SQL
2 votes129 views1 answer
SQL IF ELSE
SQL
0 vote139 views1 answer
Psql initialization
SQL
4 votes138 views1 answer
Oracle error compilation line
SQL
0 vote198 views1 answer
How do you insert boolean to postgresql
SQL
3 votes134 views1 answer
Sql multiple column index
SQL
0 vote147 views1 answer
Porcentaje sql
SQL
0 vote144 views1 answer
Get first 3 letter of department name in sql
SQL
0 vote133 views1 answer
SQL COMO ALTERA NOME DE TABELA
SQL