BETWEEN AND NOT BETWEEN Operator in php

 SELECT with BETWEEN Operator Syntax :

SELECT column1, column2, column3... FROM table_name WHERE column_name BETWEEN value1 AND value2;


SELECT with NOT BETWEEN Operator Syntax :

SELECT column1, column2, column3...FROM table_name WHERE column_name NOT BETWEEN value1 AND value2;


If we want to select records whose age is BETWEEN 18 to 20 from table name "personal" using BETWEEN Operator as shown below sql query :

SELECT * FROM personal WHERE age BETWEEN 18 AND 20;


If we want to select records whose age is NOT BETWEEN 18 to 20 from table name "personal" using NOT BETWEEN Operator as shown below sql query :

SELECT * FROM personal WHERE age NOT BETWEEN 18 AND 20;


If we want to select records whose id is BETWEEN 2 to 8 from table name "personal" using BETWEEN Operator as shown below sql query :

SELECT * FROM personal WHERE id BETWEEN 2 AND 8;


If we want to select records whose id is NOT BETWEEN 2 to 8 from table name "personal" using NOT BETWEEN Operator as shown below sql query :

SELECT * FROM personal WHERE id NOT BETWEEN 2 AND 8;


If we want to select records whose name is starting from "a" to "k" from table name "personal" using BETWEEN Operator as shown below sql query :

SELECT * FROM personal WHERE name BETWEEN "a" AND "k";


If we want to apply full name whose name is starting from "anil" and "kamal" from table name "personal" using BETWEEN Operator as shown below sql query :

Here  below we applied full names in range, it will count only first character of name. For Example, here we have applied "anil" and "kamal", it will consider only "a" and "k", will not consider whole name.

SELECT * FROM personal WHERE name BETWEEN "anil" AND "kamal";


If we want to select records whose date of birth is starting from "1999-01-01" to "1999-06-30" from table name "personal" using BETWEEN Operator as shown below sql query :

SELECT * FROM personal WHERE birth_date BETWEEN "1999-01-01" AND "1999-06-30";

Comments

Post a Comment

Popular posts from this blog

Logical_Operators

  <?php     $age = 20 ;     $age1 = 25 ;     if ( $age >= 18 && $age <= 21 )     {         echo "You are Eligible<br>" ;     }         if ( $age >= 18 || $age <= 21 )     {         echo "You are Eligible<br>" ;     }     //Below condition is True So that "Not Operator(!)" will return False condition     if (!( $age >= 18 ))     {         echo "You are Eligible<br>" ;     }     //Below condition is False So that "Not Operator(!)" will return True condition     if (!( $age <= 18 ))     {         echo "You are Eligible<br>" ;     }     //If both condition is "True" OR "False" at that time xor will return "False" and if one condition is     //"True" and s...
Read more

Get Functions

  <?php //There are many Get Functions in PHP as shown below: //get_class, get_parent_class, get_class_methods, get_class_vars, get_object_vars, get_called_class, //get_declared_classes, get_declared_interfaces, get_declared_traits, class_alias class ParentClass {     function name ()     {         echo "Class Name : " . get_class ( $this ) . "<br>" ;   //Print the particualr Class Name         //Print the particular Parent Class Name as shown below:         echo "Parent Class Name : " . get_parent_class ( $this ) . "<br>" ;     } } class ChildClass extends ParentClass {     function __construct ()     {}     function myfunction ()     {}     function myfunction2 ()     {} } $obj = new ChildClass (); $obj -> name (); echo "Class Name is : " . get_class ( $obj ) . "<br>" ; echo "Paren...
Read more

print_Statement

  <?php     echo "Hello, Welcome Everyone" ;     echo "<b>Hello" , "World</b>" ;     echo "<h1>Hello" . " brother</h1>" ;     echo "<h1><i>Let's" . " come</i></h1>" ;     echo 2364789 ;     echo 43.98 ; //  OUTPUT: // Hello, Welcome EveryoneHelloWorld // Hello brother // Let's come // 236478943.98 Hello World ? > < html >     < head >         < title > PHP </ title >     < head >     < body >         <?php             echo "Hello World" ;         ? >     </ body > </ html >
Read more