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 vote277 views1 answer
Customer using hdfc bank sql query
SQL
0 vote219 views1 answer
Select mysql limit to 2 decimal places
SQL
0 vote282 views1 answer
Sql: extract day text from datetime value
SQL
2 votes251 views3 answers
Write sql query to find the second highest salary of employee
SQL
1 vote217 views1 answer
Mssql string length
SQL
3 votes246 views2 answers
Funktion LOWER/UPPER sql
SQL
0 vote270 views1 answer
Sqlite löschen einer tabelle
SQL
2 votes257 views1 answer
Query any digits record
SQL
1 vote249 views1 answer
Mysql remove last empty newline
SQL
3 votes245 views1 answer
Delete all content in table mysql
SQL