Mega Code Archive

 

Categories / MySQL / Select Clause

 

Simple demo for IN

/* mysql> Drop table report; Query OK, 0 rows affected (0.00 sec) mysql> CREATE TABLE report (     ->        article INT(4),     ->        dealer  CHAR(20),     ->        price   DOUBLE(16,2)     -> ); Query OK, 0 rows affected (0.05 sec) mysql> INSERT INTO report VALUES (1,'A',4.45),     ->                         (1,'B',5.45),     ->                         (2,'A',16.67),     ->                         (3,'B',6.12),     ->                         (3,'C',2.78),     ->                         (3,'D',2.34),     ->                         (4,'D',21.29); Query OK, 7 rows affected (0.01 sec) Records: 7  Duplicates: 0  Warnings: 0 mysql> SELECT * FROM report; +---------+--------+-------+ | article | dealer | price | +---------+--------+-------+ |       1 | A      |  4.45 | |       1 | B      |  5.45 | |       2 | A      | 16.67 | |       3 | B      |  6.12 | |       3 | C      |  2.78 | |       3 | D      |  2.34 | |       4 | D      | 21.29 | +---------+--------+-------+ 7 rows in set (0.01 sec) mysql> SELECT *     -> FROM report     -> WHERE dealer IN("A","C","D"); +---------+--------+-------+ | article | dealer | price | +---------+--------+-------+ |       1 | A      |  4.45 | |       2 | A      | 16.67 | |       3 | C      |  2.78 | |       3 | D      |  2.34 | |       4 | D      | 21.29 | +---------+--------+-------+ 5 rows in set (0.00 sec) */ Drop table report;   CREATE TABLE report (        article INT(4),        dealer  CHAR(20),        price   DOUBLE(16,2) ); INSERT INTO report VALUES (1,'A',4.45),                         (1,'B',5.45),                         (2,'A',16.67),                         (3,'B',6.12),                         (3,'C',2.78),                         (3,'D',2.34),                         (4,'D',21.29);      SELECT * FROM report;        SELECT * FROM report WHERE dealer IN("A","C","D");