How to Select direct Json decode object from table column in mysql in php

 

price_formula refrence_code status
{“firstcolumn”:”defaultprice”,”exchangerate”:”1.44″,”commission”:”8″,”calculationtype”:”flat”} MBB 1

 

 SELECT *,price_formula->>‘$.firstcolumn‘ as firstcolumn,price_formula->>‘$.exchangerate’ as exchangerate,price_formula->>‘$.commission’ as commission,price_formula->>‘$.calculationtype’ as calculationtype FROM account_master where refrence_code=MBB‘ AND status=1 AND is_deleted=0 AND sync_product=‘1’

Leave a Reply

Your email address will not be published. Required fields are marked *