Arrow
Logo

MySql

Introduction to SQL

SQL Database

SQL Table

SQL Warnings

SQL Keys

SQL where clause

SQL between operator

SQL logical operators

SQL like operator

SQL refining operator

SQL aggregate function

SQL CRUD Operations

SQL Functions

SQL Date Time Data Type

SQL Joins

SQL between operator

AuthorHariom Prajapati

Pubish Date03 Jul 2022

categoryMySql

 

between

The between operator use to  select values (numbers, text or dates ) between  given range.

 

Syntax -

Select * from table_name where column_name between value1 and value2;

OR

Select * from table_name where column_name  <= data (highest data) && column_name >= data (lowest data) ;

 

Not between

The not between use to  select values (numbers, text or dates ) from outside the given range .