Arrow

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 .