1

We ran a batch import to pull in several hundred entries, but some fields got imported incorrectly. For example, all the websites imported as "link", when they should have been blank.

Can someone help me with a command to run in the SQL manager that will clear all the values of a custom field?

EE2.10.1, Channel ID 9, Field ID 60

Thanks!

0

This'll do it. However, as always... back up your exp_channel_data table before doing anything, especially if you're not a developer or DB admin.

UPDATE exp_channel_data 
    SET field_id_60 = ""
    WHERE channel_id = "9";
| improve this answer | |
  • perfect! fixed several hundred entries in seconds. – Marketing Alliance Oct 2 '15 at 15:51

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.