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


1 Answer 1


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";
  • perfect! fixed several hundred entries in seconds. Commented Oct 2, 2015 at 15:51

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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