Delete specific values from column with where condition

Question

I want to delete specific values data from one column with the WHERE condition  Putting in another way  I don t want to delete the complete row  Is it possible

User · Answer

UPDATE YourTable SET columnName   null WHERE YourCondition

User · Answer

You don t want to delete if you re wanting to leave the row itself intact  You want to update the row  and change the column value   The general form for this would be an UPDATE statement   UPDATE  lt table name gt  SET     ColumnA    lt NULL  or     or whatever else is suitable for the new value for the column gt  WHERE     ColumnA    lt bad value gt     or any other search conditions

User · Answer

You can also use REPLACE    UPDATE Table    SET Column   REPLACE Column   Test123    Test

User · Answer

Try this SQL statement  update Table set Column    Column - your val

User · Answer

UPDATE myTable     SET myColumn   NULL   WHERE myCondition

[sql] Delete specific values from column with where condition?

Examples related to sql

Examples related to sql-server

Examples related to sql-update