Can we use delete function to delete just the specific value of a specific column?

Question

i.e. delete if value = condition. we are not deleting the whole row.

Answer 1

If you want to delete a particular value (which is as good as assigning it to null), use
UPDATE table_name SET my_col = NULL
WHERE condition

I don't think we can use delete for that purpose.

Answer 2

ya olcay is right you have to update table for that particular cell , delete function will Delete whole row according to condition