Mysql between condition

The MYSQL BETWEEN condition specifies how to retrieve values from an expression within a specific range. 
It is used with SELECT, INSERT, UPDATE and DELETE statement.

Syntax:
select * from tablename where  expression BETWEEN value1 AND value2;    

Select Statement:
select * from forum;

Result:

Between Condition
select * from forum where forumid between 5 and 10;

Result:
MySQL BETWEEN condition with date:
select * from forum where created_Time between '2016-11-25' and '2017-01-04'
Result:

Post a Comment

0 Comments