SELECT  `id` ,  `attribs_json`
FROM  `products`
WHERE  `attribs_json` REGEXP  '"1":{"value":[^"3"$]'

{"feature":{"1":{"value":"["2","3"]"},
            "2":{"value":["1"]},
            "5":{"value":""},
            "3":{"value":["1"]},
            "9":{"value":""},
            "4":{"value":"u0633u0627u062au0646"},
            "6":{"value":""},
            "7":{"value":""},
            "8":{"value":""}
           },
"show_counter":"0",
"show_counter_discount":""
}}

SELECT products.* FROM `products`
INNER JOIN `product_features` ON products.ID = product_features.product_id
WHERE product_features.feature_id = '1' OR product_features.feature_id = '3'

SELECT id FROM table_name WHERE field_name REGEXP '"key_name":"([^"])key_word([^"])"';
or
SELECT id FROM table_name WHERE field_name RLIKE '"key_name":"[[:<:]]key_word[[:>:]]"';