Jump to content

How to clean a column in bulk? by SQL

Recommended Posts

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

Link to comment
Share on other sites


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

  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Create New...