Select from a list of values from JSON encoded data
I got a solution:


Single check of value in JSON array

SELECT * FROM `nw_object_detail` 
WHERE ((`details` like '%"screen_type":"%LED%"%'))

One value from multiple possibilities 

SELECT * FROM `nw_object_detail`
WHERE ((`details` like '%"screen_type":[%"%LCD%"%]%') 



PHP Solution

if(count($options)&gt;1): 
    $condition = '(';
    $count = 1;
    foreach( $options as $option ): 
        $condition .= '(`details` like \'%"'.$key.'":[%"%'.$option.'%"%]%\')';
        if(count($options)!=$count): 
            $condition .= ' OR ';
        endif;
    endforeach;
$condition .= ')';