Use IN for static values : In « Select Clause « SQL / MySQL






  1. SQL / MySQL
  2. Select Clause
  3. In

Use IN for static values

  
Drop table sales;
  
CREATE TABLE sales(
    num MEDIUMINT NOT NULL AUTO_INCREMENT,
    name CHAR(20),
    winter INT,
    spring INT,
    summer INT,
    fall INT,
    category CHAR(13),
    primary key(num)
)type=MyISAM;


insert into sales value(1, 'Java', 1067 , 200, 150, 267,'Holiday');
insert into sales value(2, 'C',970,770,531,486,'Profession');
insert into sales value(3, 'JavaScript',53,13,21,856,'Literary');
insert into sales value(4, 'SQL',782,357,168,250,'Profession');
insert into sales value(5, 'Oracle',589,795,367,284,'Holiday');
insert into sales value(6, 'MySQL',953,582,336,489,'Literary');
insert into sales value(7, 'Cplus',752,657,259,478,'Literary');
insert into sales value(8, 'Python',67,23,83,543,'Holiday');
insert into sales value(9, 'PHP',673,48,625,52,'Profession');

select * from sales;


SELECT name AS Name, category AS Category
FROM sales
WHERE category IN("Profession", "Holiday");








Related examples in the same category

1.Simple demo for IN
2.Use IN and order rows
3.Simple demo for NOT IN
4.Use IN for string value
5.Use IN and BETWEEN AND
6.Use IN in where clause
7.Find the match numbers and the number of sets won and lost of all matches that were won 3-1 or 3-2.
8.In operator and char type
9.SELECT statement uses the NOT IN operator
10.Constant value with in opertator
11.Comparisons with a large number of values can be carried out easily with IN:
12.Sub query with IN command
13.Sub query with NOT IN command