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 votes201 views1 answer
Metasploit start postgresql
SQL
7 votes174 views1 answer
Safe update mysql
SQL
0 vote198 views1 answer
Sql update subtract value
SQL
1 vote191 views1 answer
Oracle activate job
SQL
1 vote174 views1 answer
Check constraint to check if date greater than todays date
SQL
-1 vote186 views1 answer
SQL query to convert DD/MM/YYYY to YYYY-MM-DD
SQL
0 vote186 views1 answer
Stored function in sql
SQL
0 vote195 views1 answer
Oracle session statistics
SQL
1 vote185 views3 answers
Alter schema sql server
SQL
0 vote158 views1 answer
Sql query with date
SQL