AND and OR may be intermixed : OR « Where Clause « SQL / MySQL






  1. SQL / MySQL
  2. Where Clause
  3. OR

AND and OR may be intermixed

 
/*

mysql> select * from Bird;
+----------+-------+---------+------+------------+-------+
| name     | owner | species | sex  | birth      | death |
+----------+-------+---------+------+------------+-------+
| BlueBird | Joe   | Car     | f    | 1999-03-30 | NULL  |
| RedBird  | Yin   | Bus     | m    | 1979-03-30 | NULL  |
+----------+-------+---------+------+------------+-------+
2 rows in set (0.00 sec)

mysql>  /*although AND has higher precedence than OR*/
mysql> SELECT * FROM Bird WHERE (species = 'Car' AND sex = 'm')
    ->       OR (species = 'Bus' AND sex = 'f');
Empty set (0.00 sec)


*/
Drop table Bird;

CREATE TABLE Bird (
    name VARCHAR(20), 
    owner VARCHAR(20),
    species VARCHAR(20), 
    sex CHAR(1), 
    birth DATE, 
    death DATE
);
  
INSERT INTO  Bird VALUES ('BlueBird','Joe','Car','f','1999-03-30',NULL);
INSERT INTO  Bird VALUES ('RedBird','Yin','Bus','m','1979-03-30',NULL);
  
select * from Bird;
  
 /*although AND has higher precedence than OR*/
  
SELECT * FROM Bird WHERE (species = 'Car' AND sex = 'm')
      OR (species = 'Bus' AND sex = 'f');








Related examples in the same category

1.An OR operator
2.Combine conditions in select clause
3.Combine condition with OR
4.SELECT statement includes two expressions within the WHERE clause
5.SELECT statement includes three expressions connected with an AND operator and an OR operator