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 vote120 views1 answer
Capitole toulouse
SQL
0 vote121 views1 answer
Oracle archivemode
SQL
0 vote134 views1 answer
Java nosql sort
SQL
0 vote105 views1 answer
Generate random & unique mysql string
SQL
0 vote113 views1 answer
How to user id to show in from date to upto date in mssql server
SQL
0 vote121 views1 answer
Less than and between in sql query
SQL
0 vote171 views1 answer
Drop view sql
SQL
0 vote315 views1 answer
Create pl/sql stored procedure
SQL
0 vote160 views1 answer
Postgres extract number from string
SQL
1 vote74 views1 answer
Pagination sql
SQL