Jump to content

How to clean a column in bulk? by SQL

Featured Replies

Posted

Hello,

Would anyone know to inform me a code to clear the following column in bulk?

Table: cms_custom_database_1 > Column: field_9

By "clear" do you mean to remove the value stored in the field_9 column for each row of the table, leaving it blank for all rows?

Or to remove the field_9 row itself from the table?

 

(If the former, this would work but, for safety, be certain you make a database backup first!)

UPDATE cms_custom_database_1 SET field_9 = '';

That will make the value for field_9 blank/empty in each row (but not NULL).

  • Author

@Mark H Yes, remove the value, leaving it blank.

Archived

This topic is now archived and is closed to further replies.

Recently Browsing 0

  • No registered users viewing this page.