mysql 的JSON_LENGTH 函数获取json字段中的array字符串时结果总是返回一?

例如字段例如registered_result存储着以下字符串,我用这个sql语句获取json array的长度,为什么结果总是返回1呢?

`SELECT JSON_LENGTH(registered_result )FROM query_record WHERE XXX LIMIT 1
`

"[{\"category\":\"videoLive\",\"country\":\"CN\",\"description_CN\":\"9158视频交友平台是金华就约我吧网络科技有限公司所开发的中国最大的实时社交视频平台之一。\",\"httpResponse\":\"{“info“:“很遗憾,用户名已注册“,“status“:“n“}\",\"location\":{\"country\":\"CN\"},\"logoImage\":\"static-libs/logos/videoLive/_9158.jpg\",\"logoImageBig\":\"static-libs/logos/videoLive/_9158Big.jpg\",\"name_CN\":\"9158聚乐网\",\"name_EN\":\"9158.com\",\"url\":\"http://passport.9158.com/register_mobile.html\"},{\"category\":\"lifeService\",\"country\":\"CN\",\"description_CN\":\"58同城是国内领先的生活分类信息网站,海量生活信息免费发布查询。提供找房子、找工作、二手物品买卖、二手车、58团购、商家黄页、宠物票务、旅游交友等多种生活信息。\",\"httpResponse\":\"\",\"location\":{\"country\":\"CN\"},\"logoImage\":\"static-libs/logos/lifeService/_58.jpg\",\"logoImageBig\":\"static-libs/logos/lifeService/_58Big.jpg\",\"name_CN\":\"58同城\",\"name_EN\":\"58.com\",\"url\":\"https://passport.58.com/reg/\"},{\"category\":\"digital\",\"country\":\"CN\",\"description_CN\":\"新全的flyme固件更新;flyme软件商店提供海量应用供用户下载;flyme云服务提供用户帐号与数据管理服务;flyme论坛为用户提供沟通交流平台;品牌窗口展示新的flyme资讯。\",\"httpResponse\":\"<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">\n<html xmlns=\"http://www.w3.org/1999/xhtml\">\n<head>\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\" />\n<title>查找好友 魅族社区 </title>\n\n<meta name=\"keywords\" content=\"\" />\n<meta name=\"description\" content=\",魅族社区\" />\n<meta name=\"generator\" content=\"MEIZU 2013\" />\n<meta name=\"author\" content=\"MEIZU\" />\n<meta name=\"copyright\" content=\"2003-2013 Comsenz Inc.\" />\n<meta name=\"MSSmartTagsPreventParsing\" content=\"True\" />\n <meta name=\"msapplication-tap-highlight\" content=\"no\" />\n<meta http-equiv=\"MSThemeCompatible\" content=\"Yes\" /><link rel=\"stylesheet\" type=\"text/css\" href=\"data/cache/style_1_common.css?kGA\" /><link rel=\"stylesheet\" type=\"text/css\" href=\"data/cache/style_1_home_spacecp.css?kGA\" /><script type=\"text/javascript\">\n \tfunction getCookie(objName){//获取指定名称的cookie的值 \n \t var arrStr = document.cookie.split(\"; \"); \n \t for(var i = 0;i < arrStr.length;i ++){ \n \t var temp = arrStr[i].split(\"=\"); \n \t if(temp[0] == objName) \n \t return unescape(temp[1]); \n \t }\n \t return false;\n}\nvar cookiepre = 'MZBBS_2132_';\nvar uc_cookiepre = 'MZBBSUC_2132_';\nvar cookie_mobile = getCookie(cookiepre + 'mobile');\n\nvar location_href = window.location.href.split('?')[0];\nlocation_href = location_href.replace(/https:\\/\\/|http:\\/\\//, '');\nvar static_index = location_href == 'bbs.meizu.cn/' \n|| location_href == 'bbs.meizu.cn' \n|| location_href == 'bbs.meizu.cn/index.html'\n|| location_href == 'bbs.meizu.cn/index.php';\n\nif(!navigator.userAgent.match(/pad|gt-p1000/i) && cookie_mobile !== 'no' && static_index \n&& navigator.userAgent.match(/android|webos|ip(hone|od)|opera (mini|mobi|tablet)|iemobile|windows.+phone|mobile|fennec|kindle (Fire)|maemo|blackberry|playbook|bb10\\; (touch|kbd)|Symbian(OS)|Ubuntu Touch/i)){\nif( !/flymebrowser/i.test(location.href) ) window.location.href='//bbs.meizu.cn/index.php?mobile=yes';\n}\n\nvar STYLEID = '1', STATICURL = 'static/', IMGDIR = 'https://bbs.res.meizu.com/resources/php/bbs/static/image/common', VERHASH = 'kGA', charset = 'utf-8', discuz_uid = '0', cookiepre = 'MZBBS_2132_', cookiedomain = '', cookiepath = '/', showusercard = '0', attackevasive = '0', disallowfloat = 'login|newthread|tradeorder|activity|debate|usergroups|task', creditnotice = '', defaultstyle = '', REPORTURL = 'aHR0cDovL2Jicy5tZWl6dS5jbi9ob21lLnBocD9tb2Q9c3BhY2VjcCZhYz1zZWFyY2gmdXNlcm5hbWU9YXNkYXNkJnNlYXJjaHN1Ym1pdD15ZXM=', SITEURL = '';//, JSPATH = 'https://bbs.res.meizu.com/resources/php/bbs/static/js/';\n \nJSPATH = \"https://bbs.res.meizu.com/resources/php/bbs/static/js/\";\n// 是否是手机浏览器\nvar BROWSER_IS_MOBILE\t= 0;\t\t// 手机浏览器\nif(!window.pgvMain) window.pgvMain = function() {}\n </script>\n<script src=\"//bbs.res.meizu.com/static_new/pc/js/common/common-e367c2e526.js\" type=\"text/javascript\"></script>\n\n<link rel=\"stylesheet\" type=\"text/css\" href=\"//bbs.res.meizu.com/static_new/pc/css/index/common-49d764df8a.css\" />\n\n <meta property=\"wb:webmaster\" content=\"f1284c3017204ff7\" />\r\n <meta property=\"qc:admins\" content=\"1300463313655125636\" />\r\n<meta name=\"application-name\" content=\"魅族社区\" />\r\n <meta name=\"msapplication-tap-highlight\" content=\"no\" />\r\n<meta name=\"msapplication-tooltip\" content=\"魅族社区\" />\r\n<meta name=\"msapplication-task\" content=\"name=;action-uri=https://bbs.meizu.cn/portal.php;icon-uri=https://bbs.res.meizu.com/resources/php/bbs/static/image/common/portal.ico\" /><meta name=\"msapplication-task\" content=\"name=版块;action-uri=https://bbs.meizu.cn/forum.php;icon-uri=https://bbs.res.meizu.com/resources/php/bbs/static/image/common/bbs.ico\" />\r\n<meta name=\"msapplication-task\" content=\"name=;action-uri=https://bbs.meizu.cn/group.php;icon-uri=https://bbs.res.meizu.com/resources/php/bbs/static/image/common/group.ico\" />\r\n <script src=\"//bbs.res.meizu.com/static_new/pc/js/common/jquery-1-6da57f4a2b.7.1.min.js?kGA\" type=\"text/javascript\"></script>\r\n <script src=\"//bbs.res.meizu.com/static_new/pc/js/common/home-9377160b24.js?kGA\" type=\"text/javascript\"></script>\r\n\r\n <script src=\"//bbs.res.meizu.com/static_new/pc/js/common/public-32cee01080.js\" type=\"text/javascript\"></script>\r\n <script src=\"//bbs.res.meizu.com/static_new/pc/js/common/jquery-ee452c3167.elements.js?kGA\" type=\"text/javascript\"></script>\r\n\r\n <link href=\"//bbs.res.meizu.com/resources/php/bbs/static/newstyle/main.v1.css\" rel=\"stylesheet\" type=\"text/css\" />\r\n \r\n \r\n</head>\r\n\r\n<body id=\"nv_home\" class=\"pg_spacecp\" onkeydown=\"if(event.keyCode==27) return false;\">\r\n<div id=\"append_parent\"></div><div id=\"ajaxwaitid\"></div>\r\n<div id=\"hd\">\r\n <div id=\"w_header\">\r\n <div class=\"border-wrap\">\r\n <div id=\"meizu-header\" class=\"bbs-header\">\r\n <div class=\"head-nav-r\">\r\n <a class=\"download\" href=\"javascript:;\" target=\"_blank\">APP下载</a>\r\n </div>\r\n <a href=\"https://www.meizu.com\" target=\"_blank\">官网</a>\r\n <a href=\"https://www.flyme.cn/\" target=\"_blank\">Flyme</a>\r\n <a href=\"http://retail.meizu.com/index.html\" target=\"_blank\">专卖店</a>\r\n <a href=\"http://care.meizu.com/\" target=\"_blank\">服务</a>\r\n </div>\r\n <div class=\"app-down-wp\" id=\"appDownWp\" style=\"display: none;\">\r\n <div class=\"app-down-content\">\r\n <img src=\"//bbs.res.meizu.com/static_new/pc/pic/935524fa-9d0b-420b-a485-105974823f40.jpg\" alt=\"\">\r\n <a class=\"app-down-link-2 app-down-link\" target=\"_blank\" href=\"https://hd.meizu.com/share/app_download.html\"><img src=\"//www3.res.meizu.com/static/cn/_partial/header/images/app_down_icon_1_a2c5374.png\" alt=\"\"></a>\r\n <a class=\"app-down-link-3 app-down-link\" target=\"_blank\" href=\"http://app.flyme.cn/apps/public/detail?package_name=com.meizu.flyme.flymebbs\"><img src=\"//www3.res.meizu.com/static/cn/_partial/header/images/app_down_icon_1_a2c5374.png\" alt=\"\"></a>\r\n </div>\r\n </div>\r\n </div>\r\n \r\n <div class=\"nav-wrap\">\r\n <div class=\"bbs-nav\" id=\"nv\">\r\n <div class=\"bbs-logo\">\r\n <a href=\"https://bbs.meizu.cn\">\r\n <img src=\"https://bbs.res.meizu.com/static_new/pc/pic/logo_blue_new.png\" alt=\"\">\r\n <span>社区</span>\r\n </a> \r\n </div>\r\n\r\n <div class=\"fr\">\r\n <div id=\"user-avatar\">\r\n <div id=\"mzCust\">\r\n <div id=\"bbs-avatar\">\r\n <img src=\"//www3.res.meizu.com/static/cn/_partial/header/images/icon-user_47dae1a.jpg\" alt=\"\">\r\n <a href=\"https://bbs.meizu.cn/home.php?mod=space&amp;do=pm\" class=\"news-icon\">0</a>\r\n </div>\r\n \r\n <div id=\"user-menu\" style=\"display:none;\">\r\n <i class=\"arrow\"></i>\r\n <ul class=\"notloglist\">\r\n <li>\r\n <a id=\"mzLogin\" href=\"/index.php?mod=login\">立即登录</a>\r\n </li>\r\n <li>\r\n <a id=\"mzRegister\" href=\"/login.php?act=register\">立即注册</a>\r\n </li>\r\n <li class=\"split tips-text\">\r\n <span>其他方式登录</span>\r\n </li>\r\n <li class=\"other-login lastchild\">\r\n <a href=\"javascript:;\" class=\"ico weibo\">微博</a>\r\n <a href=\"javascript:;\" class=\"ico weixin\">微信</a>\r\n </li>\r\n </ul>\r\n <ul class=\"loglist\" style=\"display:none;\">\r\n <li><a href=\"https://member.meizu.com/uc/webjsp/member/detail\">我的账户</a></li>\r\n <li class=\"spliter\"></li>\r\n <li><a href=\"//bbs.meizu.cn/home.php?mod=follow\">我的动态</a></li>\r\n <li><a href=\"//bbs.meizu.cn/forum.php?mod=guide&amp;view=my\">我的帖子</a></li>\r\n <li><a href=\"//bbs.meizu.cn/home.php?mod=space&amp;do=friend\">我的好友</a></li>\r\n <li class=\"my-message\">\r\n <a href=\"//bbs.meizu.cn/home.php?mod=space&amp;do=pm\" id=\"pm_ntc\">我的消息</a>\r\n </li>\r\n <li><a href=\"//bbs.meizu.cn/home.php?mod=spacecp\">个人设置</a></li>\r\n <li class=\"spliter\"></li>\r\n <li class=\"lastchild\"><a class=\"logout_mzcust\" id=\"mzLogout\" href=\"//bbs.meizu.cn/logout.php?\">退出账户</a></li>\r\n </ul>\r\n </div>\r\n </div>\r\n </div>\r\n </div>\r\n \r\n <div class=\"search-wrap\">\r\n <div id=\"scbar\" class=\"cl\">\n<form id=\"scbar_form\" method=\"post\" autocomplete=\"off\" onsubmit=\"searchFocus($('scbar_txt'))\" action=\"search.php?searchsubmit=yes\" target=\"_blank\">\n<input type=\"hidden\" name=\"mod\" id=\"scbar_mod\" value=\"search\" />\n<input type=\"hidden\" name=\"formhash\" value=\"518eb9bd\" />\n<input type=\"hidden\" name=\"srchtype\" value=\"title\" />\n<input type=\"hidden\" name=\"srhfid\" value=\"0\" />\n<input type=\"hidden\" name=\"srhlocality\" value=\"home::spacecp\" />\n <div class=\"scbar_wrap\">\n \t<input type=\"text\" name=\"srchtxt\" id=\"scbar_txt\" value=\"搜索话题和用户\" autocomplete=\"off\" />\n <button type=\"submit\" name=\"searchsubmit\" id=\"scbar_btn\" sc=\"1\" value=\"true\"></button>\n </div>\n\n</form>\n</div>\n<div class=\"cr\"> </div>\n<ul id=\"scbar_type_menu\" class=\"p_pop\" style=\"display: none;\"><li><a href=\"javascript:;\" rel=\"forum\" class=\"curtype\">帖子</a></li><li><a href=\"javascript:;\" rel=\"user\">用户</a></li></ul>\n<script type=\"text/javascript\">\ninitSearchmenu('scbar', '');\n</script>\n </div>\r\n\r\n <ul class=\"bbs-menu\">\r\n <li>\r\n <a href=\"/\">精选</a>\r\n </li>\r\n <li>\r\n <a href=\"/forum-22-1.html\" target=\"_blank\">综合讨论</a>\r\n </li>\r\n <li class=\"forums\">\r\n <a target=\"_blank\">版块</a>\r\n </li>\r\n <li>\r\n <a href=\"https://bbs.meizu.cn/photo\" target=\"_blank\">影像馆</a>\r\n </li>\r\n <li>\r\n <a href=\"http://myj.meizu.com/\" target=\"_blank\">魅友家</a>\r\n </li>\r\n </ul>\r\n </div>\r\n\r\n <div class=\"bbs-all-menu\">\r\n <i class=\"all-menu-arrow\"></i>\r\n <dl class=\"menu-item\">\r\n <dt class=\"blueitem\">产品</dt>\r\n <dd>\r\n <a target=\"_blank\" href=\"/forum-22-1.html\">综合讨论</a>\r\n <a target=\"_blank\" href=\"/forum-149-1.html\">魅族手机</a>\r\n <a target=\"_blank\" href=\"/forum-138-1.html\">智能配件</a>\r\n <a target=\"_blank\" href=\"/forum-60-1.html\">Flyme</a>\r\n </dd>\r\n </dl>\r\n <dl class=\"menu-item\">\r\n <dt class=\"greenitem\">活动</dt>\r\n <dd>\r\n <a target=\"_blank\" href=\"/forum-84-1.html\">摄影天地</a>\r\n <a target=\"_blank\" href=\"/forum-104-1.html\">魅友家</a>\r\n <a target=\"_blank\" href=\"/forum-196-1.html\">魅客</a>\r\n </dd>\r\n </dl>\r\n <dl class=\"menu-item\">\r\n <dt class=\"greenitem\">生活</dt>\r\n <dd>\r\n <a target=\"_blank\" href=\"/forum-10-1.html\">谈天说地</a>\r\n <a target=\"_blank\" href=\"/forum-20-1.html\">二手交易</a>\r\n </dd>\r\n </dl>\r\n <dl class=\"menu-item lastchild\">\r\n <dt class=\"yellowitem\">服务</dt>\r\n <dd class=\"lastchild\">\r\n <a target=\"_blank\" href=\"/forum-6-1.html\">售后服务</a>\r\n <a target=\"_blank\" href=\"/forum-13-1.html\">社区办公室</a>\r\n </dd>\r\n </dl>\r\n </div>\r\n </div>\r\n </div> <!--header-->\r\n\r\n</div>\r\n \r\n<div id=\"wp\" class=\"wp\">\r\n<div id=\"ct\" class=\"ct2_a wp cl\">\n<div class=\"back_left bdl\"><dl class=\"a\" id=\"lf_\">\n<dt>个人中心</dt>\n<dd >\n<a href=\"home.php?mod=follow\" title=\"动态\">动态</a>\n</dd>\n\n<dd >\n<a href=\"forum.php?mod=guide&amp;view=my\" title=\"帖子\">帖子</a>\n</dd>\n\n<dd class=\"bdl_a\" >\n<a href=\"home.php?mod=follow&amp;do=following\" title=\"关系\">关系</a>\n</dd>\n\n<dd >\n<a href=\"home.php?mod=space&amp;do=pm\" title=\"消息\">消息</a>\n</dd>\n\n<!--\n<dd >\n<a href=\"home.php?mod=space&amp;do=album&amp;view=me\" title=\"相册\">相册</a>\n</dd>\n\n<dd >\n<a href=\"home.php?mod=space&amp;do=wall\" title=\"留言板\">留言板</a>\n</dd>\n\n<dd >\n<a href=\"#\" title=\"荣誉\">荣誉</a>\n</dd>\n-->\n\n<dd >\n<a href=\"home.php?mod=spacecp&amp;ac=profile&amp;op=base\" title=\"设置\">设置</a>\n</dd>\n\n<dd ></dd>\n\n<dd>\n<a href=\"app.php?mod=shop&amp;action=my\" title=\"兑换单\">兑换单</a>\n</dd>\n\n<dd>\n<a href=\"app.php?mod=lottery&amp;action=my\" title=\"中奖记录\">中奖记录</a>\n</dd>\n\n <dd >\n \t<div style=\"height:18px; width:100%;\"></div>\n </dd>\n</dl></div>\n<div class=\"mn cont_wp float_l\">\n<div class=\"bm bw0 page_frame_navigation\">\n<div class=\"follow_feed_cover\" style=\"left:342px;\" ></div>\n<ul class=\"tb cl page_frame_ul\" style=\"padding-left:20px;\" >\n<li><a href=\"home.php?mod=follow&amp;do=following\">收听</a></li>\n<li><a href=\"home.php?mod=follow&amp;do=follower\">听众</a></li>\n<li><a href=\"home.php?mod=space&amp;do=friend\">好友</a></li>\n<li class=\"a\"><a href=\"home.php?mod=spacecp&amp;ac=search\">搜索</a></li>\n</ul>\n </div>\n<div class=\"tips_sresult\"><h3>以下是查找到的用户列表(最多显示 100 个),您还可以<a href=\"home.php?mod=spacecp&amp;ac=search\">换个搜索条件试试</a></h3></div><div class=\"sresult_ulist\">\n<ul class=\"buddy cl relat_ulist\">\n <li class=\"bbda cl\" >\n <div class=\"flw_avt\"><a class=\"avatar\" href=\"home.php?mod=space&amp;uid=159053494\" target=\"_blank\" ><img src=\"https://image-res.mzres.com/img/download/uc/15/90/53/49/40/159053494/w50h50?t=1585318089\" onerror=\"this.onerror=null;this.src='https://bbs.res.meizu.com/static/image/noavatar_big.gif'\" /><span class=\"shadowbox_avatar\"> </span></a></div>\n <div class=\"cont_ulist\">\n<h4 class=\"uname_sresult\">\n<a href=\"space-uid-159053494.html\" title=\"asdasd_ko\" target=\"_blank\" style=\"color:#999999;\">asdasd_ko</a>\n</h4>\n<p class=\"maxh\">\n<font color=\"#999999\">铜牌会员</font> </p>\n<div class=\"xg1\">\n<a href=\"javascript:;\" id=\"interaction_159053494\" onmouseover=\"showMenu(this.id);\" class=\"showmenu\">互动<span class=\"arrow_gray\"></span></a>\n<a href=\"home.php?mod=spacecp&amp;ac=friend&amp;op=add&amp;uid=159053494\" id=\"a_friend_159053494\" onclick=\"showWindow('friend_159053494', this.href, 'get', 0)\" title=\"加为好友\">加为好友</a>&nbsp;&nbsp;&nbsp;&nbsp;<a href=\"home.php?mod=spacecp&amp;ac=follow&amp;op=add&amp;hash=518eb9bd&amp;fuid=159053494\" id=\"a_followmod_159053494\" onclick=\"showWindow('followmod', this.href, 'get', 0)\">收听</a></div>\n<div id=\"interaction_159053494_menu\" class=\"p_pop\" style=\"display: none; width: 80px;\" tleft=\"true\">\n<p><a href=\"home.php?mod=space&amp;uid=159053494&amp;do=profile\" target=\"_blank\" title=\"查看资料\">查看资料</a></p>\n<p><a href=\"space-uid-159053494.html\" target=\"_blank\" title=\"去串个门\">去串个门</a></p>\n<p><a href=\"home.php?mod=spacecp&amp;ac=poke&amp;op=send&amp;uid=159053494\" id=\"a_poke_159053494\" onclick=\"showWindow(this.id, this.href, 'get', 0);\" title=\"打个招呼\">打个招呼</a></p>\n<p><a href=\"home.php?mod=spacecp&amp;ac=pm&amp;op=showmsg&amp;handlekey=showmsg_159053494&amp;touid=159053494&amp;pmid=0&amp;daterange=2\" id=\"a_sendpm_159053494\" onclick=\"showWindow('showMsgBox', this.href, 'get', 0)\" title=\"发送消息\">发送消息</a></p>\n</div>\n</div>\n<div class=\"cr\"></div>\n </li>\n <li class=\"bbda cl\" >\n <div class=\"flw_avt\"><a class=\"avatar\" href=\"home.php?mod=space&amp;uid=24709469\" target=\"_blank\" ><img src=\"https://image-res.mzres.com/img/download/uc/24/70/94/69/00/24709469/w50h50?t=1585318089\" onerror=\"this.onerror=null;this.src='https://bbs.res.meizu.com/static/image/noavatar_big.gif'\" /><span class=\"shadowbox_avatar\"> </span></a></div>\n <div class=\"cont_ulist\">\n<h4 class=\"uname_sresult\">\n<a href=\"space-uid-24709469.html\" title=\"Asdasd开心\" target=\"_blank\" style=\"color:#999999;\">Asdasd开心</a>\n</h4>\n<p class=\"maxh\">\n<font color=\"#999999\">铜牌会员</font> </p>\n<div class=\"xg1\">\n<a href=\"javascript:;\" id=\"interaction_24709469\" onmouseover=\"showMenu(this.id);\" class=\"showmenu\">互动<span class=\"arrow_gray\"></span></a>\n<a href=\"home.php?mod=spacecp&amp;ac=friend&amp;op=add&amp;uid=24709469\" id=\"a_friend_24709469\" onclick=\"showWindow('friend_24709469', this.href, 'get', 0)\" title=\"加为好友\">加为好友</a>&nbsp;&nbsp;&nbsp;&nbsp;<a href=\"home.php?mod=spacecp&amp;ac=follow&amp;op=add&amp;hash=518eb9bd&amp;fuid=24709469\" id=\"a_followmod_24709469\" onclick=\"showWindow('followmod', this.href, 'get', 0)\">收听</a></div>\n<div id=\"interaction_24709469_menu\" class=\"p_pop\" style=\"display: none; width: 80px;\" tleft=\"true\">\n<p><a href=\"home.php?mod=space&amp;uid=24709469&amp;do=profile\" target=\"_blank\" title=\"查看资料\">查看资料</a></p>\n<p><a href=\"space-uid-24709469.html\" target=\"_blank\" title=\"去串个门\">去串个门</a></p>\n<p><a href=\"home.php?mod=spacecp&amp;ac=poke&amp;op=send&amp;uid=24709469\" id=\"a_poke_24709469\" onclick=\"showWindow(this.id, this.href, 'get', 0);\" title=\"打个招呼\">打个招呼</a></p>\n<p><a href=\"home.php?mod=spacecp&amp;ac=pm&amp;op=showmsg&amp;handlekey=showmsg_24709469&amp;touid=24709469&amp;pmid=0&amp;daterange=2\" id=\"a_sendpm_24709469\" onclick=\"showWindow('showMsgBox', this.href, 'get', 0)\" title=\"发送消息\">发送消息</a></p>\n</div>\n</div>\n<div class=\"cr\"></div>\n </li>\n <li class=\"cr\" style=\"height:0px;margin:0px;padding:0px !important;\"></li>\n</ul>\n</div>\n<div style=\"height:1px;clear:both;\"> </div>\n <script type=\"text/javascript\">\nfunction succeedhandle_followmod(url, msg, values) {\nvar fObj = $('a_followmod_'+values['fuid']);\nif(values['type'] == 'add') {\nfObj.innerHTML = '取消收听';\nfObj.className = 'flw_btn_unfo';\nfObj.href = 'home.php?mod=spacecp&ac=follow&op=del&fuid='+values['fuid'];\n} else if(values['type'] == 'del') {\nfObj.innerHTML = '收听';\nfObj.className = 'flw_btn_fo';\nfObj.href = 'home.php?mod=spacecp&ac=follow&op=add&hash=518eb9bd&fuid='+values['fuid'];\n}\n}\nhoverAdd(\".sresult_ulist li\",\"ihover_sresult\");\n</script>\n\n</div>\n</div>\n<script type=\"text/javascript\">\ncheckFun(\".wrap_simcheck\",\"checked_simcheck\");\nsimSelectFun(\".relat_search select\");\n</script><script type=\"text/javascript\">\nfunction goto_mobile_href(){\nvar f = window.location.href;\nif(f.indexOf('mobile=no') !== -1){ // 从pc跳到H5\nwindow.location.href = f.replace(/mobile=no/,'mobile=yes');\n} else if(f.indexOf('mobile=yes') >0 ){ // 已经是H5页\nlocation.reload();\n}else if(f === 'https://bbs.meizu.cn' || f === 'https://bbs.meizu.cn/'){\nwindow.location.href = f + 'index.php?mobile=yes';\n}else if(f.substr(-11) == '/index.html'){\nwindow.location.href = f.replace('/index.html', '/index.php?mobile=yes');\n}else if(f.substr(-1) == '/' || f.substr(-4) == 'html' || f.substr(-3) == 'php'){\nwindow.location.href = f + '?mobile=yes';\n}else{\nwindow.location.href = f + '&mobile=yes';\n}\n}\n</script>\n\n<div id=\"g_upmine_menu\" class=\"tip tip_3\" style=\"display:none;\">\n<div class=\"tip_c\">\n积分 0, 距离下一级还需 积分\n</div>\n<div class=\"tip_horn\"></div>\n</div>\n<script type=\"text/javascript\">\nscrolltop_obj \t= new goto_top();\nscrolltop_obj.init();\n</script>\n</div>\n<!--footer start -->\n<div class=\"meizu-footer\" id=\"meizu-footer\">\n<div class=\"footer-inner\">\n<div class=\"meizu-row\">\n<div class=\"meizu-footer-info\">\n<div class=\"meizu-footer-info-left\">\n<ul class=\"clearfix\">\n<li>\n<a href=\"https://www.meizu.com/about.html?click=gw_index_yw_more_1\" target=\"_blank\">\n了解魅族\n</a>\n</li>\n<li>\n<a href=\"http://hr.meizu.com/?click=gw_index_yw_more_2\" target=\"_blank\">\n加入我们\n</a>\n</li>\n<li>\n<a href=\"https://www.meizu.com/contact.html?click=gw_index_yw_more_3\" target=\"_blank\">\n联系我们\n</a>\n</li>\n<li>\n<a href=\"http://www.flyme.cn/?click=gw_index_yw_more_4\" target=\"_blank\">\nFlyme\n</a>\n</li>\n<li>\n<a href=\"http://www.meizu.com/\" target=\"_blank\">\n魅族官网\n</a>\n</li>\n<li>\n<a href=\"https://meizu.tmall.com/?click=gw_index_yw_more_6\" target=\"_blank\">\n天猫旗舰店\n</a>\n</li>\n<li>\n<a href=\"https://www.meizu.com/feedback.html?click=gw_index_yw_more_7\" target=\"_blank\">\n问题反馈\n</a>\n</li>\n<li>\n<a href=\"https://www.meizu.com/authorization.html?click=gw_index_yw_more_8\" target=\"_blank\">\n线上销售授权名单公示\n</a>\n</li>\n<li>\n<a href=\"https://cimg2.res.meizu.com/www/meizu/publish_license.pdf?click=gw_index_yw_more_9\" target=\"_blank\">\n出版物经营许可证\n</a>\n</li>\n<li class=\"no-border\" id=\"meizu-footer-langList\">\n<div id=\"meizu-footer-language\" class=\"meizu-footer-language\">\n<span class=\"button-language\">\n<i class=\"icon-lang-logo icon-lang-logo-cn\"></i>简体中文\n<ul id=\"lang_list_footer\" class=\"lang_list_\" style=\"display: none;\">\n<li class=\"footerLi\"><a href=\"https://www.meizu.com/index.html\"><i style=\"background-image:url(https://fms.res.meizu.com/dms/2017/12/18/1c31db15-ab85-4932-8e6c-edfd6039bc60.png);background-position: 0 0;\" class=\"lang-logo lang-logo-index.html\"></i><span>简体中文</span></a></li>\n<li class=\"footerLi\"><a href=\"https://www.meizu.com/hk\"><i style=\"background-image:url(https://fms.res.meizu.com/dms/2017/12/18/85fba643-95ca-4db1-991c-43e66f108afb.png);background-position: 0 0;\" class=\"lang-logo lang-logo-hk\"></i><span>繁體中文</span></a></li>\n<li class=\"footerLi\"><a href=\"https://mymeizu.ru \"><i style=\"background-image:url(https://fms.res.meizu.com/dms/2017/12/18/e743e97c-71af-4853-a91d-bd81c2d3a31c.png);background-position: 0 0;\" class=\"lang-logo lang-logo-ru\"></i><span>Русский</span></a></li>\n<li class=\"footerLi\"><a href=\"https://www.meizu.com/en/\"><i style=\"background-image:url(https://fms.res.meizu.com/dms/2017/12/18/2ca9de93-02cb-4ded-ab0a-c497dcf06c5a.png);background-position: 0 0;\" class=\"lang-logo lang-logo-en/\"></i><span>English</span></a></li></ul>\n</span>\n</div>\n</li>\n</ul>\n\n\n<div class=\"meizu-footer-language-wp clearfix\">\n\n</div>\n\n<div class=\"meizu-footer-certificate\">\n©2020 Meizu Telecom Equipment Co., Ltd. All rights reserved.&nbsp;&nbsp;&nbsp;&nbsp;\n<a target=\"_blank\" href=\"http://www.miitbeian.gov.cn/\" hidefocus=\"true\">粤ICP备13003602号</a>\n<a target=\"_blank\" href=\"//www3.res.meizu.com/static/cn/_partial/footer/images/icp2_fb8db74.jpg\" hidefocus=\"true\">合字B2-20170010 </a>\n<a target=\"_blank\" href=\"//www3.res.meizu.com/static/cn/_partial/footer/images/com_licence_b00fe42.jpg\" hidefocus=\"true\">营业执照</a>\n<a target=\"_blank\" href=\"https://www.meizu.com/legal.html\" hidefocus=\"true\">法律声明</a>\n<span class=\"footer-info-record\" target=\"_blank\" href=\"\">\n<i></i>\n粤公网安备 44049102496009 号\n</span>\n<a class=\"footer-info-license\" target=\"_blank\" rel=\"nofollow\" href=\"http://210.76.65.188/\" hidefocus=\"true\">\n<i></i>\n</a>\n<a class=\"footer-info-wel\" target=\"_blank\" rel=\"nofollow\" href=\"http://210.76.65.188/webrecord/innernet/Welcome.jsp?bano=4404013010531\"\n hidefocus=\"true\">\n<i></i>\n</a>\n<a class=\"footer-info-trust\" target=\"_blank\" rel=\"nofollow\" href=\"https://credit.szfw.org/CX20151204012550820380.html\" hidefocus=\"true\">\n<i></i>\n</a>\n</div>\n</div>\n</div>\n</div>\n</div>\n</div>\n<!--footer end -->\n<script src=\"//bbs.res.meizu.com/static_new/pc/js/common/mzheader-ac23965d30.js\" type=\"text/javascript\"></script>\n<!--百度统计-->\n<script type=\"text/javascript\">\nvar _hmt = _hmt || [];\n(function() {\nvar hm = document.createElement(\"script\");\nhm.src = \"https://hm.baidu.com/hm.js?286d9c6c54e45134ec2445db56e87565\";\nvar s = document.getElementsByTagName(\"script\")[0];\ns.parentNode.insertBefore(hm, s);\n})();\n\n//分享活动统计\nif(getCookie('MZBBS_2132_invitecode') && getCookie('MZBBSUC_2132_loginmember')){\n document.write(\"<script src='https://bbs-app.meizu.cn/index.php?mod=invite&action=resolve'><\\/script>\"); \n}\n\n</script>\n\n\n\n<script>\n;(function(_) {\nvar _bar = _('.choose-bar');\n_bar.on('click', 'a.bar-item', function() {\nvar that = _(this);\nvar input = that.closest('.choose-bar').find('input.pc')\n_('input.pc').prop('checked', false);\ninput.prop('checked', true);\nvar type = that.data('mod')\nmodthreads(type);\n\n});\n})(window.jQuery)\n</script>\n</body>\n</html>\",\"location\":{\"country\":\"CN\"},\"logoImage\":\"static-libs/logos/digital/flyme.jpg\",\"logoImageBig\":\"static-libs/logos/digital/flymeBig.jpg\",\"name_CN\":\"魅族\",\"name_EN\":\"flyme.cn\",\"url\":\"https://i.flyme.cn/uc/system/webjsp/forgetpwd/toPhone\"},{\"category\":\"digital\",\"country\":\"CN\",\"description_CN\":\"搞趣网是专注于手机游戏垂直领域的媒体网站,为手游玩家提供新好玩的苹果iphone手机游戏下载、安卓游戏免费下载,还有新鲜的手机游戏资讯、攻略、评测,以及手机网游礼包发放、玩家交流等,是手游爱好者爱的专业网站。\",\"httpResponse\":\"{“info“:“用户名已经存在!“,“status“:“n“}\",\"location\":{\"country\":\"CN\"},\"logoImage\":\"static-libs/logos/digital/gao7.jpg\",\"logoImageBig\":\"static-libs/logos/digital/gao7Big.jpg\",\"name_CN\":\"搞趣網\",\"name_EN\":\"gao7.com\",\"url\":\"https://udb.gao7.com/Account/Register?pid=1\"},{\"category\":\"game\",\"country\":\"CN\",\"description_CN\":\"399是中国领先的小游戏专业网站,免费为你提供小游戏大全,4399洛克王国小游戏,双人小游戏,连连看小游戏,赛尔号,奥拉星,奥奇传说小游戏,造梦西游3等新小游戏。\",\"httpResponse\":\"jQuery110208153288981333031_1578369927455({“status“:true})\",\"location\":{\"country\":\"CN\"},\"logoImage\":\"static-libs/logos/game/_4399.jpg\",\"logoImageBig\":\"static-libs/logos/game/_4399Big.jpg\",\"name_CN\":\"4399游戏网\",\"name_EN\":\"4399 game\",\"url\":\"https://u.4399.com/anquan/pwd/?from=u&sfrom=\"},{\"category\":\"bank\",\"country\":\"CN\",\"description_CN\":\"中国建设银行官网\",\"httpResponse\":\"\r\n{\r\n “data“:“B2CMainPlatP1“,\r\n “domain“:““\r\n} \",\"location\":{\"country\":\"CN\"},\"logoImage\":\"static-libs/logos/bank/ccb.jpg\",\"logoImageBig\":\"static-libs/logos/bank/ccbBig.jpg\",\"name_CN\":\"中国建设银行\",\"url\":\"https://ibsbjstar.ccb.com.cn/CCBIS/V6/common/login.jsp\"},{\"category\":\"digital\",\"country\":\"CN\",\"description_CN\":\"安卓市场,android,安卓,安智市场-国内专业的android安卓手机电子市场,提供海量安卓软件、android手机游戏、安卓新汉化软件资源及新apk汉化、汉化破解app、apk免费下载\",\"httpResponse\":\"{“code“:207,“msg“:“该用户名已注册,可直接登录“,“success“:false}\",\"location\":{\"country\":\"CN\"},\"logoImage\":\"static-libs/logos/digital/anzhi.jpg\",\"logoImageBig\":\"static-libs/logos/digital/anzhiBig.jpg\",\"name_CN\":\"安智网\",\"name_EN\":\"anzhi.com\",\"url\":\"http://i.anzhi.com/web/account/register\"},{\"category\":\"digital\",\"country\":\"CN\",\"description_CN\":\"机锋论坛是全球大、用户量多、资源全面的中文安卓论坛,拥有海量的rom、游戏、软件资源,同时为玩家们提 供新热的安卓手机资源,各种刷机教程。搞机就上机锋网。\",\"httpResponse\":\"{“code“:“25“,“message“:“密码错误“}\",\"location\":{\"country\":\"CN\"},\"logoImage\":\"static-libs/logos/digital/gfan.jpg\",\"logoImageBig\":\"static-libs/logos/digital/gfanBig.jpg\",\"name_CN\":\"机锋\",\"name_EN\":\"gfan.com\",\"url\":\"http://my.gfan.com/findPwd\"},{\"category\":\"game\",\"country\":\"CN\",\"description_CN\":\"当乐网d.cn作为中国专注原创的手机游戏媒体网站,为上亿玩家提供全球新好玩的游戏资讯。游戏评测、攻略视频、专题企划、行业采访等有深度有价值内容让你全方位拥抱游戏乐趣\",\"httpResponse\":\"{\n\t“code“:2000,\n\t“data“:[\n\t\t{\n\t\t\t“email“:““,\n\t\t\t“emailVisible“:““,\n\t\t\t“encryted“:null,\n\t\t\t“imgUrl“:“avatar/100.jpg“,\n\t\t\t“lastLoginTime“:“2008-05-19 10:47:50“,\n\t\t\t“mid“:1627,\n\t\t\t“password“:““,\n\t\t\t“phoneNumber“:““,\n\t\t\t“phoneVisible“:““,\n\t\t\t“username“:“asdasd“\n\t\t}\n\t]\n}\",\"location\":{\"country\":\"CN\"},\"logoImage\":\"static-libs/logos/game/dangle.jpg\",\"logoImageBig\":\"static-libs/logos/game/dangleBig.jpg\",\"name_CN\":\"当乐网\",\"url\":\"https://kf.d.cn/#/selectAccount?tag=\"}]"

阅读 13k
2 个回答

您好,找一个json格式化工具格式化一下,看一下上下级关系是不是错了

SELECT JSON_LENGTH(registered_result )FROM query_record WHERE XXX LIMIT 1
问一下哈,最后这个limit 1操作,难道不是说你只取一条数据么?

撰写回答
你尚未登录,登录后可以
  • 和开发者交流问题的细节
  • 关注并接收问题和回答的更新提醒
  • 参与内容的编辑和改进,让解决方法与时俱进
推荐问题
宣传栏