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 vote158 views1 answer
Sql select column names starting with
SQL
0 vote159 views1 answer
Get last date join sql
SQL
0 vote161 views1 answer
Rows, INSERT INTO, Returning
SQL
1 vote155 views3 answers
Mysql Server Start
SQL
6 votes203 views3 answers
Mysql change auto_increment start value
SQL
0 vote233 views1 answer
Postgres list all stored procedures query
SQL
0 vote183 views1 answer
Mysql config slave
SQL
1 vote164 views2 answers
Backup table mssql
SQL
2 votes249 views1 answer
Sql ends with string
SQL
0 vote180 views1 answer
Create dabase postgresql
SQL