we are using Opencart 220.127.116.11. we need to select with a query values inside a shell because the custom fields in OC are in a shell in a row in oc_orders table.
I would like to select in orders table the custom fields. the select command in MySql gives me all the data in shell.
I have in customer 4 custom fields mobile phone , VAT. company name and company profession
I want to select the order_id in MySQL and show me the mobile phone and VAT in different columns.
I want to have in my select command different columns.
for example for the data as follow the next table
sql command : select order_id , custom_field where order_id = 800
gives me this:
and I want to have this:
order_id|mobile phone | vat | company name | company profession
800 |6946066448 | 061336572 | \u03a6\u03c1\u03b1a\u03b3\u03ba\u03b9\u03b1 | \u0397\u03a1\u0391\u039a\u039b\u0395\u0399\u039f\u03a5
Also when we finish the query we need to transform the characters for example \u03a5 to greek characters