You are viewing a single comment's thread from:

RE: 请MSSQL高手指点一下JSON的问题

in #cn7 years ago (edited)

就好象我用于中日韩报告这样 📊🌏中日韩龙虎榜自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   

Coin Marketplace

STEEM 0.22
TRX 0.26
JST 0.040
BTC 98409.57
ETH 3478.48
USDT 1.00
SBD 3.24