我正在使用將數(shù)據(jù)插入數(shù)據(jù)庫(kù)json_encoded?，F(xiàn)在，我要搜索“功能”，但不能。MySQL查詢：SELECT `id` , `attribs_json` FROM `products` WHERE `attribs_json` REGEXP '"1":{"value":[^"3"$]'該查詢向我顯示所有鍵為“ 1”且值是任何東西而不是“ 3”的行我的數(shù)據(jù)是：{"feature":{"1":{"value":"["2","3"]"}, "2":{"value":["1"]}, "5":{"value":""}, "3":{"value":["1"]}, "9":{"value":""}, "4":{"value":"\u0633\u0627\u062a\u0646"}, "6":{"value":""}, "7":{"value":""}, "8":{"value":""} },"show_counter":"0","show_counter_discount":""}}
3 回答
慕姐8265434
TA貢獻(xiàn)1813條經(jīng)驗(yàn) 獲得超2個(gè)贊
如果您使用的是MySQL最新版本，則可以幫助您滿足要求。
select * from products where attribs_json->"$.feature.value[*]" in (1,3)
添加回答
舉報(bào)
0/150
提交
取消