Where query in mysql

Example:

select * from mydoubts_table_users where name=’vasanthan’

output
——
——————————————————
|id|Name |Age|
——————————————————
|1|vasanthan|32|
——————————————————-