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 vote222 views1 answer
Mysql database hyphen
SQL
0 vote231 views1 answer
Vbscript connect mssql
SQL
3 votes214 views3 answers
Create table in microsoft sql server
SQL
1 vote204 views1 answer
Create index concurrently postgres
SQL
0 vote212 views1 answer
Java input type sql date
SQL
1 vote237 views2 answers
Oracle leftmost characters
SQL
0 vote213 views1 answer
Sql Top 5 sutradara dengan filem terbanyak
SQL
1 vote215 views1 answer
Media sql
SQL
3 votes252 views1 answer
Sql double index
SQL
2 votes249 views1 answer
Get the mysql table columns data type mysql
SQL