opencart -sql selection in values in a shell

Cerrado Publicado hace 5 años Pagado a la entrega
Cerrado Pagado a la entrega

we are using Opencart 3.0.2.0. 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.

For example

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:

{"4":"6946066448","6":"061336572","1":"\u03a6\u03c1\u03b1a\u03b3\u03ba\u03b9\u03b1","3":"\u0395\u03c1\u03b3\u03bf\u03bb\u03ac\u03b2\u03bf\u03c2 \u039f\u03b9\u03ba\u03bf\u03b4\u03cc\u03bc\u03c9\u03bd","5":"\u0397\u03a1\u0391\u039a\u039b\u0395\u0399\u039f\u03a5"}

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

MySQL Open Cart PHP Arquitectura de software

Nº del proyecto: #17477842

Sobre el proyecto

9 propuestas Proyecto remoto Activo hace 5 años

9 freelancers están ofertando un promedio de €33 por este trabajo

webifynet

I can do it .

€28 EUR en 1 día
(3 comentarios)
3.0
shopshoppy

can do

€12 EUR en 1 día
(17 comentarios)
4.8
sakshee1591993

Hello Hope you are fine. Let me introduce myself as l have an experience of 2.5 years in Web development, Web Designing, Open cart,MySQL, JavaScript, HTML,Bootstrap, CSS, Php. Discuss more about your project with me. Más

€29 EUR en 2 días
(6 comentarios)
2.4