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

13 votes115 views11 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysql.sock' (2) Ask
SQL
2 votes114 views2 answers
Oracle multiple insert
SQL
1 vote109 views1 answer
Sql server 2012 query history
SQL
4 votes127 views2 answers
Bulk kill mysql processlist
SQL
10 votes101 views1 answer
Oracle dependency
SQL
0 vote130 views1 answer
Convert multiple columns to ROws in sql server
SQL
0 vote113 views1 answer
Mysql multiple group by
SQL
1 vote109 views1 answer
Reutrn string after character sql
SQL
5 votes119 views2 answers
Oracle tables with column name
SQL
0 vote132 views2 answers
Sql query print strings and int
SQL