v.s's avatar
Level 6

JSON Search

Hi, I Have json column : {"en": "Cupiditate assumenda est labore.", "ka": "Quaerat molestias qui vel pariatur qui recusandae doloribus."}

I want to search inside it, but a query (LIKE) must be applied to the values. "en" and "ka" should be ignored. I come to this: Post::where('name->ka', 'LIKE', '%some text%') ->orWhere('name->ka', 'LIKE', '%some text%') ->get()

0 likes
1 reply

Please or to participate in this conversation.