#Example for “=”.
select * from mydoubts_table_users where name=’vasanthan’
——————————————————
|id|Name |Age|
——————————————————
|1|vasanthan|32|
——————————————————-
#Example for “!=”
select * from mydoubts_table_users where name!=’vasanthan’
output
——
——————————————————
|id|Name |Age|
——————————————————
|2|John |44|
|3|Michael |34|
|4|Rani |39|
|5|Raina |38|
|6|Rajendra |25|
|7|Sharon |18|
——————————————————-
#Example for “>”
select * from mydoubts_table_users where age>29
output
——
——————————————————
|id|Name |Age|
——————————————————
|1|vasanthan|32|
|2|John |44|
|3|Michael |34|
|4|Rani |39|
|5|Raina |38|
——————————————————-
#Example for “<" select * from mydoubts_table_users where age<29 output ------ ------------------------------------------------------ |id|Name |Age| ------------------------------------------------------ |6|Rajendra |25| |7|Sharon |18| ------------------------------------------------------- #Example for ">=”
select * from mydoubts_table_users where age>=39
output
——
——————————————————
|id|Name |Age|
——————————————————
|2|John |44|
|4|Rani |39|
——————————————————-
#Example for “<=" select * from mydoubts_table_users where age<=32 output ------ ------------------------------------------------------ |id|Name |Age| ------------------------------------------------------ |1|vasanthan|32| |6|Rajendra |25| |7|Sharon |18| -------------------------------------------------------