SELECT with WHERE clause tutorial

 SELECT column1, column2, column3... FROM table_name;

For Rename Column: 

For Example: Column name is id, name, age, gender, phone, city and we have to change column name to ID, Name, Age, Gender, Phone, City in table name "personal" then we can change as shown below Sql command:

SELECT id AS ID, name AS Name, age AS Age, gender AS Gender, phone AS Phone, city AS City FROM personal;

For add Space between two words in Column Name by Renaming Column name:

For Example: Column name is Student and we have to change column name to "Student Name" then we can change as shown below Sql command:

SELECT id AS ID, name AS "Student Name", age AS Age, gender AS Gender, phone AS Phone, city AS City FROM personal;


SELECT with WHERE Clause Syntax:

SELECT column1, column2, column3... FROM table_name WHERE condition;

WHERE Comparison Operators as shown below :

=                                Equal

>                                Greater than

<                                Less than

>=                              Greater than or equal

<=                              Less than or equal

<> Or !=                    Not equal

BETWEEN                Between a certain range

LIKE                           Search for a pattern

IN                                To specify multiple possible values for a column


If we want to select any particular record from database, For Example : Select "gender" and "city" column from table "personal" and gender must be Female then we can use  below Sql command as shown below :

SELECT gender, city FROM personal WHERE gender = "F";

If we want to select records from table "personal" whose age Less than 20 then we can use below Sql command as shown below :

SELECT * FROM personal WHERE age < 20;

If we want to select records from table "personal" whose city is not equal to "Agra" then we can use below command as shown below : 

SELECT * FROM personal WHERE city != "Agra";

If we want to select any particular column record from table "personal" For Example: Select "id" and "age" column from table "personal" and condition is that city is not equal to "Agra" then we can use below Sql command as shown below :

SELECT id, age FROM personal WHERE city != "Agra";

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