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

Compétences : MySQL, OpenCart, PHP, Architecture Logicielle

En voir plus : 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

Concernant l'employeur :
( 1 commentaire ) METAMORFOSI, Greece

Nº du projet : #17477842

9 freelances font une offre moyenne de 33 € pour ce travail

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 0 jours
(219 Commentaires)
%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(75 Commentaires)

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 2 jours
(65 Commentaires)

I can do it .

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(3 Commentaires)

can do

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(17 Commentaires)

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(9 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 2 jours
(6 Commentaires)

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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(2 Commentaires)
%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(0 Commentaires)