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 vote128 views1 answer
How to delete a record from sqlite in android
SQL
1 vote156 views2 answers
Mysql add column tinyint default 0
SQL
6 votes127 views4 answers
Sqlite drop table
SQL
22 votes138 views3 answers
How to join three tables in sql using joins
SQL
0 vote129 views1 answer
Pgsql is not permitted to log in
SQL
0 vote133 views2 answers
Pl sql auto increment
SQL
0 vote145 views1 answer
Test database for sql
SQL
0 vote157 views1 answer
Select all same column value in sql
SQL
3 votes146 views2 answers
Oracle apex view logs
SQL
1 vote147 views1 answer
Postgres format date in select
SQL