laravel search JSON field valuee in MySQL

Question

the attribute column stores json

{
 "size":  [432, 433, 434], 
 "color": [17, 23, 56], 
 "brand": [36], 
 "type":  [12,13,14,15]
}

help me make a query in laravel to search for records that have, for example: color = [17, 23]

Probably answered here. https://stackoverflow.com/questions/36320711/search-a-mysql-column-with-a-json-string-for-a-specific-value — zinmyintnaung, Aug 12 '21 at 05:37
This might help you https://laravel.com/docs/8.x/queries#json-where-clauses — S N Sharma, Aug 12 '21 at 06:03

score 0 · Answer 1 · answered Aug 12 '21 at 08:49

where you gonna implement that search option ? in dropdown? if you use it in blade dropdown go through this link https://www.webslesson.info/2017/02/live-search-json-data-using-ajax-jquery.html#:~:text=After%20loading%20JSON%20File%20data%20we%20want%20search,format%20and%20here%20we%20can%20search%20by%20

and if you going to search in controller/model use the steps mention below

first, use json_decode and convert it into an array then use another variable to store what you goona filter then use below example to filter filtering json data in php laravel

laravel search JSON field valuee in MySQL

1 Answers1