You are viewing a single comment's thread from:

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

in #cn • 7 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
7 years ago in #cn by
$0.72
  • Past Payouts $0.72, 0.00 TRX
  • - Author $0.54, 0.00 TRX
  • - Curators $0.18, 0.00 TRX
2 votes
Reply 0

Coin Marketplace

STEEM 0.17
TRX 0.14
JST 0.028
BTC 58471.44
ETH 2587.53
USDT 1.00
SBD 2.44