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 vote342 views1 answer
Kill thread
SQL
0 vote341 views1 answer
Oracle create table auto generated primary key
SQL
3 votes397 views1 answer
Postgres count distinct
SQL
0 vote375 views1 answer
Show mysql account privilleges
SQL
5 votes361 views3 answers
Sql max value in column
SQL
2 votes369 views1 answer
Mysql select default if null
SQL
0 vote339 views1 answer
Sql search all columns of database oracle sql
SQL
0 vote389 views2 answers
Postgres isnull
SQL
2 votes468 views2 answers
SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE')
SQL
6 votes362 views2 answers
Stored procedure to delete data from table in mysql
SQL