Example:
Delete from STUDENTDETAILS where StudentID = 101

delete from tablename where columnname=datatype
examples:
           delete from employee where employeeid=2

You can not exactly delete the column value.
alternatively what you can do is use update statment and
update the value with blank.

update users
set user_adr = ''
where user_id = 'userid'

Rupa Bagherwal is told the answer is correct
we cant delete particular value in one column
we can update onle

delete from employee where employeeid=2
  
suppose we wil give like this means it will delete one row

for this questions update only possible