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 vote289 views2 answers
Postgresql get difference in hours between two dates
SQL
0 vote278 views1 answer
Sub query in linq
SQL
0 vote291 views1 answer
Product of a column in mysql
SQL
1 vote285 views1 answer
Sql eliminare un record
SQL
4 votes285 views2 answers
SELECT table_name FROM user_tables;
SQL
1 vote307 views2 answers
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.4.0 or newer is required; you have 0.10.1.
SQL
0 vote291 views1 answer
Mysql shell ERROR: Not connected.
SQL
1 vote281 views1 answer
Change table to innodb mysql
SQL
0 vote317 views1 answer
Local pg_sql to heroku pg_sql
SQL
0 vote284 views1 answer
Postgresql import a database of gzip
SQL