What is the difference between BETWEEN and IN operators in Mysql?

1.	What is the difference between BETWEEN and IN operators in Mysql?
Answer» Between operator is used to select a range of data between TWO values. It can be TEXTS, numbers, and DATES, etc. Syntax: Select * from TABLENAME where FIELDNAME between VALUE1 and VALUE2 IN operator is used to CHECK for a value in the given SET of values. Syntax: Select * from TABLENAME where FIELDNAME IN ('VALUE1','VALUE2',...) Related Article: What Is The Difference Between MySQL And MongoDB

Answer»

Between operator is used to select a range of data between TWO values. It can be TEXTS, numbers, and DATES, etc.

Syntax: Select * from TABLENAME where FIELDNAME between VALUE1 and VALUE2

IN operator is used to CHECK for a value in the given SET of values.

Syntax: Select * from TABLENAME where FIELDNAME IN ('VALUE1','VALUE2',...)

Related Article: What Is The Difference Between MySQL And MongoDB

Discussion