how to fetch record in codeigniter where clause using json values

Question

My question is in my table stored json encoded values like field Name : offer_promotion

 [{"name":"sample promotion","price":"1555","expdate":"2017-05-15","shortdesc":"test","longdesc":"test"}]

Now i want to write query for select records like, For eaxmple:

$this->db->where('offer_promotion', "name":"sample promotion");

How to write this query?

stackoverflow.com/questions/22544195/… check Erman Belegu answer. — Bhaskar Jain
– Bhaskar Jain, Commented May 15, 2017 at 11:53

Aniket Singh · Accepted Answer · 2017-05-15 11:56:21Z

3

json in database works as a simple string. So you have to apply logic similar as string. You can use Like

$this->db->like('offer_promotion', '%"name":"sample promotion"%');

answered May 15, 2017 at 11:56

Aniket Singh

2,6942 gold badges24 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

@KarthikSaravanan, Welcome in SO. This link may be helpful for you stackoverflow.com/help/someone-answers

Exprator · Accepted Answer · 2017-05-15 12:11:48Z

1

answered May 15, 2017 at 11:51

Exprator

27.8k6 gold badges54 silver badges64 bronze badges

How can we use php code ` json_decode($json)` in query?