Title: Column Will Not Delete
Last modified: August 22, 2016

---

# Column Will Not Delete

 *  Resolved [joeldault](https://wordpress.org/support/users/joeldault/)
 * (@joeldault)
 * [11 years, 5 months ago](https://wordpress.org/support/topic/column-will-not-delete/)
 * I have created a form that has several fields. Some of these columns titles have
   names with ” ‘ ” symbol in them. For instance, one column is named “lender’s”.
   For some reason these columns will not work with part of the short code. if the“‘”
   symbol is in the columns name. That is understandable. I have been trying to 
   delete these columns for two days. They will not delete. I have also tried to
   remain them. which will not work either. Please help. When I attempt to rename
   them to remove the “‘” symbol they renaming wrong. For instance… the name “Lender’s”.
   When I try to rename the column it changes to “Lender/’s”. When I try to delete
   it, it goes through the process but does not actually delete the column. Please
   help
 * [https://wordpress.org/plugins/contact-form-7-to-database-extension/](https://wordpress.org/plugins/contact-form-7-to-database-extension/)

Viewing 4 replies - 1 through 4 (of 4 total)

 *  Plugin Author [Michael Simpson](https://wordpress.org/support/users/msimpson/)
 * (@msimpson)
 * [11 years, 5 months ago](https://wordpress.org/support/topic/column-will-not-delete/#post-5537461)
 * The best thing to do at this point is probably rename the column in the database
   to something without the single quote in it.
 * This will replace “Lender’s” and “Lender/’s” with “Lenders”
 *     ```
       update wp_cf7dbplugin_submits
       set
       field_name = 'Lenders'
       where
       field_name = 'Lender''s' or
       field_name = 'Lender/''s'
       ```
   
 *  Thread Starter [joeldault](https://wordpress.org/support/users/joeldault/)
 * (@joeldault)
 * [11 years, 5 months ago](https://wordpress.org/support/topic/column-will-not-delete/#post-5537513)
 * I am sorry, I not nit sure what I am supposed to do with that
 *  Plugin Author [Michael Simpson](https://wordpress.org/support/users/msimpson/)
 * (@msimpson)
 * [11 years, 5 months ago](https://wordpress.org/support/topic/column-will-not-delete/#post-5537515)
 * Run that query in PHPMyAdmin for you database.
 *  Thread Starter [joeldault](https://wordpress.org/support/users/joeldault/)
 * (@joeldault)
 * [11 years, 2 months ago](https://wordpress.org/support/topic/column-will-not-delete/#post-5537767)
 * Thanks

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Column Will Not Delete’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/contact-form-7-to-database-extension_ffffff.
   svg)
 * [Contact Form DB](https://wordpress.org/plugins/contact-form-7-to-database-extension/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/contact-form-7-to-database-extension/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/)
 * [Active Topics](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/reviews/)

 * 4 replies
 * 2 participants
 * Last reply from: [joeldault](https://wordpress.org/support/users/joeldault/)
 * Last activity: [11 years, 2 months ago](https://wordpress.org/support/topic/column-will-not-delete/#post-5537767)
 * Status: resolved