opencart -sql selection in values in a shell

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

Habilidades: MySQL, Open Cart, PHP, Arquitetura de software

Veja mais: data crystal reports sql server windows application using, sql server database manipulation using macro, inserting data sql server database aspnet using, php, mysql, css, html, website design, ecommerce, software architecture, open cart, retain values form using javascript, sql 2005 connection string using asp, sql 2000 edit row using vbnet, find sql server base directory using, connect sql server web parts using microsoftapplicationblocks sharepoint, export sql server data excel using vbs, sql calculated values, website using opencart, using affiliate program opencart

Acerca do Empregador:
( 1 comentário ) METAMORFOSI, Greece

ID do Projeto: #17477842

9 freelancers estão ofertando em média €33 nesse trabalho

€50 EUR in 0 dias
(219 Comentários)
€23 EUR em 1 dia
(75 Comentários)

Hi, We've got the right expertise in Opencart customization, API integration, bug fixing, and advanced development. Recently, we've worked on Custom Affiliate Commission Coupon for Opencart 2.3.x Here are a couple o Mais

€55 EUR in 2 dias
(65 Comentários)

I can do it .

€28 EUR em 1 dia
(3 Comentários)

can do

€12 EUR em 1 dia
(17 Comentários)

Hello, Hope you are doing good! I’m Sas. I’ve carefully gone through your job posting. I am specialised in Web development industry for more than 9 years. I am very much interested in your project with all of yo Mais

€55 EUR in 3 dias
(9 Comentários)

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. Mais

€29 EUR in 2 dias
(6 Comentários)

Hello dear Hiring manager I have read your job post & being an expert Web developer, I offer myself for the job. I am having extensive knowledge and 5+ years of experience in PHP & WordPress website development u Mais

€23 EUR em 1 dia
(2 Comentários)
€23 EUR em 1 dia
(0 Comentários)