How to get an entry in codeigniter where a clause using json values

Question

My question is my table stores 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 a query to select records, for example For eaxmple:

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

How do I write this request?

+3

Karthik Saravanan May 15 '17 at 11:46

2 answers

Aniket singh · Answer 1 · 2017-05-15T11:56:21+0000

json in the database works like a simple string. So you have to apply line-like logic. You can use Like

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

Exprator · Answer 2 · 2017-05-15T11:51:56+0000