You are viewing a single comment's thread from:
RE: 请MSSQL高手指点一下JSON的问题
就好象我用于中日韩报告这样 📊🌏中日韩龙虎榜自20170811 | CJK Top Pending Payout Post since 20170811 (by @ace108)
补充...
where
( ( JSON_VALUE(cm.json_metadata,'$.tags[4]') in ('cn','china') ) or
( JSON_VALUE(cm.json_metadata,'$.tags[3]') in ('cn','china') ) or
( JSON_VALUE(cm.json_metadata,'$.tags[2]') in ('cn','china') ) or
( JSON_VALUE(cm.json_metadata,'$.tags[1]') in ('cn','china') ) or
( JSON_VALUE(cm.json_metadata,'$.tags[0]') in ('cn','china') ) or