MySQL Workbench CSV Export
Hi,
I have a forms plugin on my website that writes data to a MySQL database. I'd like to be able to export the table data to CSV but the plugin writes information about the forms fields and it's values into a single column.
For example. If I entered my first name "Brad", last name "Clarke" and "Apples" into the form than it writes this:
[{"value":"Brad","clean":false,"visible":"true","invalid":false,"cellOrder":2,"id":11,"isUpdated":true},{"value":"Clarke","clean":false,"visible":"true","invalid":false,"id":12,"isUpdated":true},{"value":"Apples","clean":false,"visible":"true","invalid":false,"id":24,"isUpdated":true}
It writes the above example into a single column..
here is the DDL for the table:
CREATE TABLE `wp_nf3_object_meta` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`parent_id` int(11) NOT NULL,
`key` longtext COLLATE utf8mb4_general_ci NOT NULL,
`value` longtext COLLATE utf8mb4_general_ci,
`meta_key` longtext COLLATE utf8mb4_general_ci,
`meta_value` longtext COLLATE utf8mb4_general_ci,
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci
Is there any way to separate the values and export them to CSV?
Thanks
Brad