mysql between Operator

MySQL between Operator is a logical operator normally used to selects values within the range , using MySQL between Operator we can specify start and end values to fetch the values in that ranges better example for between Operator is to fetch product price within specify range.suppose we a database with eCommerce product and their price , we have to display all the product between price 500 and 900 , like this circumstance using MySQL between Operator is the best choice.

Example mysql between Operator query

SELECT * FROM EProducts WHERE price BETWEEN 500 AND 900;

mysql between Operator