我正在使用將數據插入數據庫json_encoded?，F在，我要搜索“功能”，但不能。MySQL查詢：SELECT `id` , `attribs_json` FROM `products` WHERE `attribs_json` REGEXP '"1":{"value":[^"3"$]'該查詢向我顯示所有鍵為“ 1”且值是任何東西而不是“ 3”的行我的數據是：{"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貢獻1813條經驗 獲得超2個贊
如果您使用的是MySQL最新版本，則可以幫助您滿足要求。
select * from products where attribs_json->"$.feature.value[*]" in (1,3)
添加回答
舉報
0/150
提交
取消