MySQL BETWEEN Clause

In this tutorial you will learn about the MySQL BETWEEN Clause and its application with practical example.

The BETWEEN operator is used in combination with WHERE clause match or select a range of data value between two values.

Table Of Contents

Syntax:

Consider “emp_info” table:

empID empName sale
1 Mark 1000
2 Max 1500
3 Mark 1800
5 John 1500

Output:

empID empName sale
1 Mark 1000
2 Max 1500
3 Mark 1800
4 Mark 3000
5 John 1500

In this tutorial we have learn about the MySQL BETWEEN Clause and its application with practical example. I hope you will like this tutorial.