Invision Community 4: SEO, prepare for v5 and dormant account notifications Matt November 11, 2024Nov 11
Posted December 6, 20177 yr Hello, Would anyone know to inform me a code to clear the following column in bulk? Table: cms_custom_database_1 > Column: field_9
December 6, 20177 yr 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).
Archived
This topic is now archived and is closed to further replies.