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

5 votes142 views4 answers
Change auto increment mysql
SQL
-1 vote121 views1 answer
Extract Data from SQL Server into XML Format
SQL
0 vote134 views1 answer
Sql find gaps in date ranges
SQL
0 vote136 views1 answer
Get the previous column of a table in mysql
SQL
1 vote125 views1 answer
Mysql login console
SQL
0 vote166 views1 answer
Migrations.RunSQL
SQL
0 vote157 views1 answer
Mysql could not fetch tables
SQL
0 vote152 views1 answer
This week mysql
SQL
11 votes188 views3 answers
Pl sql example
SQL
0 vote161 views1 answer
How to enable mysql 5.7 root user password on linux
SQL