Live Free
Active member
I am trying to create a near duplicate custom field - that is, create a new custom user field but duplicate the all of the possible values/choices of an existing through a MySQL query, rather than manually recreating the questions (due to the number of choices this would take hours).
I have a handful of custom field questions that have 30+ answers. I could use some help creating a database query to copy the custom field values/answers from an existing question into a brand new question, or to simply query a list of custom fields into a question I've already created.
Say I create a new custom field with 30+ checkbox options How could I query the database to add the possible choices?
Would it be better to run a query or simply duplicate the table and rename the field_id?
P.S. the value choices available for both custom fields - the old and the new - should always be the same. User choice selections will vary (i.e. what are your strengths? what are your weaknesses?)
Thanks.
I have a handful of custom field questions that have 30+ answers. I could use some help creating a database query to copy the custom field values/answers from an existing question into a brand new question, or to simply query a list of custom fields into a question I've already created.
Say I create a new custom field with 30+ checkbox options How could I query the database to add the possible choices?
Would it be better to run a query or simply duplicate the table and rename the field_id?
P.S. the value choices available for both custom fields - the old and the new - should always be the same. User choice selections will vary (i.e. what are your strengths? what are your weaknesses?)
Thanks.