Tag Archives: operator in mysql/php

Operators in the where clause

#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 —— ——————————————————… Read More »