I am new with sql but trying to get at it.
I have a word press website and with the below table(my_table_1) in my SQL DB and form the data within the column3 of my_table_1 i want to create a table(wish_table) which i will be displaying in webpage with a php function ( i am not sure).
Here is my_table_1 :
I want to make a new table with the text within column3 with the column headers as: your-name, your-email, customer-enquiry-subject, customer-enquiry-details and enquiry-customer-contact.
With my limited knowledge I have created a table_2 just with column3 from my_table_1 by using the following command:
CREATE TABLE table_2 AS (SELECT form_value FROM my_table_1);
Created table_2 from above code:
My question is how do i get the text values from individual cells of column 3 of my_table_1 such as s:16:”Abhishek Bacchan”, s:23:”This is enquiry subject”, s:24:”Bla Customer Details” and s:10:”1231231233″ and insert them to get my wish_table as :
Can someone please help me or suggest me if my approach to get the data within the column3 cell is wrong as if i need to use php to get the data instead of using SQL.
THANK YOU READER