實例3-JSON根據某一個字段進行篩選 · 學習JSON

結論：果斷用 `jsonsql`。官網：http://www.trentrichardson.com/jsonsql/ 當然，有人說用其他查詢方式！如下：http://www.haorooms.com/post/js_json_JsonSQL_jfunk 。（供參考） # 如圖 ![mark](http://qiniu.newthink.cc/blog/20171123-142455387.png) # 代碼 > 這里 `where` 一定要用括號，否則查不出來。 ``` <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>Title</title> <script src="https://cdn.bootcss.com/jquery/1.11.3/jquery.js"></script>  <script src="jsonsql-0.1.js"></script> </head> <span id="test">現金</span> <body> <script> var paylist = [ {"id":"1","paymode": '1', "payname": "現金", "paymoney": "20"} , {"id":"3","paymode": '2', "payname": "支付寶", "paymoney": "50"} , {"id":"2","paymode": '1', "payname": "現金", "paymoney": "40"} ]; //根據payname現金進行篩選 var result1 = jsonsql.query('select * from paylist order by id desc',paylist); var result2 = jsonsql.query('select * from paylist where (payname=="現金") order by id desc',paylist); console.log(result1); console.log(result2); </script> </body> </html> ``` # 官方案例 ``` select title,url from json.channel.items where (category=='bla' || category=='bla bla') order by title desc limit 5,10 jsonsql.query("select * from json.channel.items order by title desc",json); jsonsql.query("select title,url from json.channel.items where (category=='javascript' || category=='vista') order by title,category asc limit 3",json); ```