How to clean a column in bulk? by SQL

[Hisashi]

Hello,

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

Table: cms_custom_database_1 > Column: field_9

[Mark H]

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).

[Hisashi]

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