SELECT statement includes three expressions connected with an AND operator and an OR operator : OR « Where Clause « SQL / MySQL

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

SELECT statement includes three expressions connected with an AND operator and an OR operator

      
mysql>
mysql> CREATE TABLE Books
    -> (
    ->     BookID SMALLINT NOT NULL PRIMARY KEY,
    ->     BookName VARCHAR(40) NOT NULL,
    ->     Category VARCHAR(15),
    ->     InStock SMALLINT NOT NULL,
    ->     OnOrder SMALLINT NOT NULL
    -> );
Query OK, 0 rows affected (0.01 sec)

mysql> INSERT INTO Books VALUES
    -> (101, 'C: Writing on Writing', 'Nonfiction', 12, 13),
    -> (102, 'Oracle', 'Fiction', 17, 20),
    -> (103, 'Opera', 'Nonfiction', 23, 33),
    -> (104, 'Notebook', 'Nonfiction', 32, 12),
    -> (105, 'Pascal', 'Fiction', 6, 35),
    -> (106, 'One Hundred Years of Solitude', 'Fiction', 28, 14),
    -> (107, 'Where I\'m Calling From', NULL, 46, 3);
Query OK, 7 rows affected (0.00 sec)
Records: 7  Duplicates: 0  Warnings: 0

mysql>
mysql> SELECT BookName, Category, InStock, OnOrder
    -> FROM Books
    -> WHERE InStock>20 AND (Category IS NULL OR NOT (Category='Fiction'))
    -> ORDER BY BookName;
+------------------------+------------+---------+---------+
| BookName               | Category   | InStock | OnOrder |
+------------------------+------------+---------+---------+
| Notebook               | Nonfiction |      32 |      12 |
| Opera                  | Nonfiction |      23 |      33 |
| Where I'm Calling From | NULL       |      46 |       3 |
+------------------------+------------+---------+---------+
3 rows in set (0.00 sec)

mysql>
mysql> drop table Books;
Query OK, 0 rows affected (0.00 sec)

   
    
    
    
    
    
  

Related examples in the same category