{"id":64224,"date":"2024-05-29T17:17:10","date_gmt":"2024-05-29T13:47:10","guid":{"rendered":"https:\/\/nabfollower.com\/blog\/mysql-using-json-data-and-not-hating-it-6lc\/"},"modified":"2024-05-29T17:17:10","modified_gmt":"2024-05-29T13:47:10","slug":"mysql-using-json-data-and-not-hating-it-6lc","status":"publish","type":"post","link":"https:\/\/nabfollower.com\/blog\/mysql-using-json-data-and-not-hating-it-6lc\/","title":{"rendered":"mysql: \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc json \u0648 \u0645\u062a\u0646\u0641\u0631 \u0646\u0628\u0648\u062f\u0646 \u0627\u0632 \u0622\u0646"},"content":{"rendered":"<p>\u062a\u0648\u0633\u0639\u0647 \u062f\u0647\u0646\u062f\u06af\u0627\u0646 \u0628\u06a9 \u0627\u0646\u062f \u0628\u0631\u0627\u06cc \u0630\u062e\u06cc\u0631\u0647 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc json \u0627\u063a\u0644\u0628 \u0627\u0632 firehose json \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u06a9\u0646\u0646\u062f \u0648 \u0627\u06cc\u0646 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0631\u0627 \u062f\u0631 \u0633\u062a\u0648\u0646\u200c\u0647\u0627\u06cc \u0645\u0631\u062a\u0628\u200c\u0634\u062f\u0647 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u062e\u0648\u062f \u0630\u062e\u06cc\u0631\u0647 \u0645\u06cc\u200c\u06a9\u0646\u0646\u062f. \u0627\u0645\u0627 \u062f\u0631 \u0628\u0631\u062e\u06cc \u0645\u0648\u0627\u0631\u062f\u060c \u0630\u062e\u06cc\u0631\u0647 \u06cc\u06a9 \u0634\u06cc \u06cc\u0627 \u0622\u0631\u0627\u06cc\u0647 json \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u06cc\u06a9 \u062d\u0628\u0627\u0628 \u0646\u06cc\u0632 \u0645\u0648\u0631\u062f \u0646\u06cc\u0627\u0632 \u0627\u0633\u062a. \u0627\u0645\u0627 MySQL \u0627\u0645\u06a9\u0627\u0646 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 json \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u06cc\u06a9 \u0646\u0648\u0639 \u062f\u0627\u062f\u0647 \u0628\u0648\u0645\u06cc \u0631\u0627 \u0641\u0631\u0627\u0647\u0645 \u0645\u06cc\u200c\u06a9\u0646\u062f \u06a9\u0647 \u0627\u062c\u0627\u0632\u0647 \u0645\u06cc\u200c\u062f\u0647\u062f \u0628\u0627 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc json \u0628\u0647 \u0631\u0648\u0634\u06cc \u062c\u0630\u0627\u0628 \u06a9\u0627\u0631 \u06a9\u0646\u06cc\u0645\u060c \u0628\u0647\u200c\u062c\u0627\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0633\u062a\u0648\u0646\u200c\u0647\u0627\u06cc text. \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u0645 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0627\u0632 json \u0627\u0633\u062a\u062e\u0631\u0627\u062c \u06a9\u0646\u06cc\u0645 \u0648 \u0627\u0632 \u0622\u0646\u0647\u0627 \u062f\u0631 WHERE \u0628\u0646\u062f\u0647\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u0645.<\/p>\n<p>\u0628\u0631\u0627\u06cc \u0627\u0633\u062a\u062e\u0631\u0627\u062c \u0645\u0642\u0627\u062f\u06cc\u0631 \u0627\u0632 json \u062f\u0631 MySQL \u0627\u0632 \u062a\u0627\u0628\u0639 JSON_EXTRACT \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f \u06a9\u0647 \u062f\u0648 \u0622\u0631\u06af\u0648\u0645\u0627\u0646\u060c \u06cc\u0639\u0646\u06cc \u0633\u062a\u0648\u0646 \u0648 \u0645\u0633\u06cc\u0631 \u0645\u0648\u0631\u062f \u0646\u0638\u0631 \u0631\u0627 \u0645\u06cc\u200c\u06af\u06cc\u0631\u062f. \u0647\u0645\u0686\u0646\u06cc\u0646 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646 \u0627\u0632 \u0639\u0645\u0644\u06af\u0631 -&gt; \u0628\u0631\u0627\u06cc \u062c\u0633\u062a\u062c\u0648\u06cc \u0633\u0631\u06cc\u0639\u062a\u0631 \u062f\u0631 json \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0631\u062f. \u0647\u0645\u0686\u0646\u06cc\u0646 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646 \u0627\u0632 JSON_UNQUOTE \u0628\u0631\u0627\u06cc \u062d\u0630\u0641 \u0646\u0642\u0644 \u0642\u0648\u0644 \u0627\u0632 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0627\u0633\u062a\u062e\u0631\u0627\u062c \u0634\u062f\u0647 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0631\u062f. \u0645\u06cc\u200c\u062a\u0648\u0627\u0646 \u0647\u0645\u0686\u0646\u06cc\u0646 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0639\u0645\u0644\u06af\u0631 ** \u0648 wildcard \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u0627\u0632 \u0622\u0631\u0627\u06cc\u0647\u200c\u0647\u0627 \u0627\u0633\u062a\u062e\u0631\u0627\u062c \u06a9\u0631\u062f.<\/p>\n<p>\u0628\u0631\u0627\u06cc \u0634\u0628\u06cc\u0647\u200c\u0633\u0627\u0632\u06cc WHERE IN \u0628\u0646\u062f\u0647\u0627 \u0627\u0632 \u0639\u0645\u0644\u06af\u0631 MEMBER OF \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f \u06a9\u0647 \u0627\u06cc\u0646 \u0639\u0645\u0644\u06af\u0631 \u0628\u0647 \u0634\u06a9\u0644\u06cc \u0645\u0634\u0627\u0628\u0647 \u062a\u0627\u0628\u0639 \u0639\u0645\u0644 \u0645\u06cc\u200c\u06a9\u0646\u062f \u0648 \u0628\u0647 \u0645\u0642\u062f\u0627\u0631 \u0633\u0645\u062a \u0686\u067e \u0622\u0646 \u0645\u06cc\u200c\u06af\u0648\u06cc\u062f \u0622\u06cc\u0627 \u062f\u0631 \u0622\u0631\u0627\u06cc\u0647 json \u0645\u0648\u062c\u0648\u062f \u0627\u0633\u062a \u06cc\u0627 \u062e\u06cc\u0631. \u0627\u06cc\u0646 \u0631\u0648\u0634 \u0628\u0647\u062a\u0631 \u0627\u0632 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 WHERE IN \u0628\u0631\u0627\u06cc \u0627\u0633\u062a\u062e\u0631\u0627\u062c \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u0627\u0632 json \u062f\u0631 MySQL \u0627\u0633\u062a. \u0647\u0645\u0686\u0646\u06cc\u0646 \u0627\u06cc\u0646 \u0631\u0648\u0634 \u0628\u0631\u0627\u06cc \u06a9\u0627\u0631 \u0628\u0627 TEXT \u0633\u062a\u0648\u0646\u200c\u0647\u0627 \u0646\u06cc\u0632 \u0645\u0639\u062a\u0628\u0631 \u0627\u0633\u062a.<\/p>\n<p>\u062f\u0631 \u06a9\u0644\u060c \u0628\u0631\u0627\u06cc \u0627\u0633\u062a\u062e\u0631\u0627\u062c \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u0627\u0632 json \u0648 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0622\u0646\u0647\u0627 \u062f\u0631 WHERE \u0628\u0646\u062f\u0647\u0627\u060c \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 json \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u06cc\u06a9 \u0646\u0648\u0639 \u062f\u0627\u062f\u0647 \u0628\u0648\u0645\u06cc \u062f\u0631 MySQL \u0645\u0648\u062b\u0631\u062a\u0631 \u0648 \u0633\u0631\u06cc\u0639\u062a\u0631 \u062e\u0648\u0627\u0647\u062f \u0628\u0648\u062f \u0648 \u0628\u0647\u062a\u0631 \u0627\u0633\u062a \u0627\u0632 \u0627\u06cc\u0646 \u0631\u0648\u0634 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0634\u0648\u062f \u062a\u0627 \u0627\u0632 TEXT \u0633\u062a\u0648\u0646\u200c\u0647\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0634\u0648\u062f.<\/p>\n<div data-article-id=\"1867939\" id=\"article-body\">\n<p>\u0627\u06cc\u0646 \u06cc\u06a9 \u062d\u0642\u06cc\u0642\u062a \u062c\u0647\u0627\u0646\u06cc \u0627\u0633\u062a \u06a9\u0647 \u06cc\u06a9\u06cc \u0627\u0632 \u06a9\u0627\u0631\u0647\u0627\u06cc \u0627\u0635\u0644\u06cc \u062a\u0648\u0633\u0639\u0647 \u062f\u0647\u0646\u062f\u06af\u0627\u0646 \u0628\u06a9 \u0627\u0646\u062f \u0646\u0648\u0634\u06cc\u062f\u0646 \u0627\u0632 firehose json \u0627\u0633\u062a \u06a9\u0647 \u0641\u0631\u0627\u0646\u062a \u0627\u0646\u062f \u0645\u062f\u0627\u0645 \u0628\u0647 \u0633\u0645\u062a \u0645\u0627 \u0627\u0633\u067e\u0631\u06cc \u0645\u06cc \u06a9\u0646\u0646\u062f.  \u0628\u0647 \u0637\u0648\u0631 \u0645\u0639\u0645\u0648\u0644\u060c \u0645\u0627 \u0647\u0645\u0647 \u0622\u0646 \u062c\u0641\u062a\u200c\u0647\u0627\u06cc \u06a9\u0644\u06cc\u062f\/\u0645\u0642\u062f\u0627\u0631 \u0631\u0627 \u0627\u0632 \u0647\u0645 \u062c\u062f\u0627 \u0645\u06cc\u200c\u06a9\u0646\u06cc\u0645 \u0648 \u0622\u0646\u0647\u0627 \u0631\u0627 \u062f\u0631 \u0633\u062a\u0648\u0646\u200c\u0647\u0627\u06cc \u0645\u0631\u062a\u0628\u200c\u0634\u062f\u0647 db \u062e\u0648\u062f \u0642\u0631\u0627\u0631 \u0645\u06cc\u200c\u062f\u0647\u06cc\u0645\u060c \u0648 \u0633\u0627\u062e\u062a\u0627\u0631 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647\u200c\u0645\u0627\u0646 \u0631\u0627 \u062e\u0648\u0628 \u0648 \u0639\u0627\u062f\u06cc \u0646\u06af\u0647 \u0645\u06cc\u200c\u062f\u0627\u0631\u06cc\u0645.  \u0627\u0645\u0627 \u06af\u0627\u0647\u06cc \u0627\u0648\u0642\u0627\u062a \u062f\u0644\u0627\u06cc\u0644 \u062e\u0648\u0628\u06cc \u0628\u0631\u0627\u06cc \u0630\u062e\u06cc\u0631\u0647 \u06cc\u06a9 \u0634\u06cc \u06cc\u0627 \u0622\u0631\u0627\u06cc\u0647 \u06a9\u0627\u0645\u0644 json \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u06cc\u06a9 \u062d\u0628\u0627\u0628 \u062a\u0645\u0627\u06cc\u0632 \u0646\u06cc\u0627\u0641\u062a\u0647 \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f. <\/p>\n<p>\u062f\u0631 \u062a\u0627\u0631\u06cc\u06a9\u06cc\u060c \u0631\u0648\u0632\u0647\u0627\u06cc \u0642\u062f\u06cc\u0645\u060c \u0627\u06cc\u0646 json \u0628\u0647 \u06cc\u06a9 <code>text<\/code> \u0633\u062a\u0648\u0646\u060c \u06a9\u0647 \u0627\u06af\u0631 \u062a\u0646\u0647\u0627 \u06a9\u0627\u0631\u06cc \u06a9\u0647 \u0645\u0627 \u0646\u06cc\u0627\u0632 \u062f\u0627\u0634\u062a\u06cc\u0645 \u0627\u06cc\u0646 \u0628\u0648\u062f \u06a9\u0647 \u0622\u0646 \u0631\u0627 \u0630\u062e\u06cc\u0631\u0647 \u06a9\u0631\u062f\u0647 \u0648 \u0628\u0631\u06af\u0631\u062f\u0627\u0646\u06cc\u0645 \u062e\u0648\u0628 \u0628\u0648\u062f.  \u0627\u0645\u0627 \u0627\u06af\u0631 \u0644\u0627\u0632\u0645 \u0628\u0648\u062f \u06a9\u0627\u0631 \u067e\u06cc\u0686\u06cc\u062f\u0647\u200c\u062a\u0631\u06cc \u0627\u0646\u062c\u0627\u0645 \u062f\u0647\u06cc\u0645\u060c \u0645\u062b\u0644\u0627\u064b \u0645\u0642\u0627\u062f\u06cc\u0631 \u062e\u0627\u0635\u06cc \u0631\u0627 \u0627\u0632 \u0622\u0646 json \u0627\u0633\u062a\u062e\u0631\u0627\u062c \u06a9\u0646\u06cc\u0645 \u06cc\u0627 \u062e\u062f\u0627\u06cc \u0646\u0627\u06a9\u0631\u062f\u0647 \u0627\u0632 \u06cc\u06a9\u06cc \u062f\u0631 \u06cc\u06a9 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u0645. <code>WHERE<\/code> \u0628\u0646\u062f\u060c \u0647\u0645\u0647 \u0686\u06cc\u0632 \u0645\u06cc \u062a\u0648\u0627\u0646\u062f \u062e\u06cc\u0644\u06cc \u0633\u0631\u06cc\u0639 \u0627\u0632 \u06a9\u0646\u062a\u0631\u0644 \u062e\u0627\u0631\u062c \u0634\u0648\u062f.<\/p>\n<p>\u062e\u0648\u0634\u0628\u062e\u062a\u0627\u0646\u0647\u060c mysql \u0645\u062f\u0631\u0646 \u067e\u0634\u062a\u06cc\u0628\u0627\u0646\u06cc \u0645\u06cc \u06a9\u0646\u062f <code>JSON<\/code> \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u06cc\u06a9 \u0646\u0648\u0639 \u062f\u0627\u062f\u0647 \u0628\u0648\u0645\u06cc\u060c \u0628\u0647 \u0645\u0627 \u0627\u0645\u06a9\u0627\u0646 \u0645\u06cc \u062f\u0647\u062f \u0628\u0627 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc json \u0628\u0647 \u0631\u0648\u0634\u06cc \u062a\u0642\u0631\u06cc\u0628\u0627 \u0644\u0630\u062a \u0628\u062e\u0634 \u06a9\u0627\u0631 \u06a9\u0646\u06cc\u0645.  \u062f\u0631 \u0627\u06cc\u0646 \u067e\u0633\u062a \u0645\u06cc \u062e\u0648\u0627\u0647\u06cc\u0645 \u0628\u0647 \u0627\u0633\u062a\u062e\u0631\u0627\u062c \u0645\u0642\u0627\u062f\u06cc\u0631 \u0627\u0632 json \u0648 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc json \u062f\u0631 \u0622\u0646 \u0628\u067e\u0631\u062f\u0627\u0632\u06cc\u0645 <code>WHERE<\/code> \u0628\u0646\u062f\u0647\u0627<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_81 counter-hierarchy ez-toc-counter-rtl ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">\u0641\u0647\u0631\u0633\u062a \u0645\u0637\u0627\u0644\u0628<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/nabfollower.com\/blog\/mysql-using-json-data-and-not-hating-it-6lc\/#%D8%A7%DB%8C%D8%AC%D8%A7%D8%AF_%DB%8C%DA%A9_JSON_%D8%B3%D8%AA%D9%88%D9%86\" >\u0627\u06cc\u062c\u0627\u062f \u06cc\u06a9 JSON \u0633\u062a\u0648\u0646<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/nabfollower.com\/blog\/mysql-using-json-data-and-not-hating-it-6lc\/#%D8%A7%D8%B3%D8%AA%D8%AE%D8%B1%D8%A7%D8%AC_%D8%A8%D8%B1%D8%AE%DB%8C_%D8%A7%D8%B2_%D8%AF%D8%A7%D8%AF%D9%87_%D9%87%D8%A7_%D8%A7%D8%B2_%D8%A2%D9%86_json\" >\u0627\u0633\u062a\u062e\u0631\u0627\u062c \u0628\u0631\u062e\u06cc \u0627\u0632 \u062f\u0627\u062f\u0647 \u0647\u0627 \u0627\u0632 \u0622\u0646 json<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/nabfollower.com\/blog\/mysql-using-json-data-and-not-hating-it-6lc\/#%D8%A8%D8%B1%D8%AE%D9%88%D8%B1%D8%AF_%D8%A8%D8%A7_%D8%A2%D8%B1%D8%A7%DB%8C%D9%87_%D9%87%D8%A7\" >\u0628\u0631\u062e\u0648\u0631\u062f \u0628\u0627 \u0622\u0631\u0627\u06cc\u0647 \u0647\u0627<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/nabfollower.com\/blog\/mysql-using-json-data-and-not-hating-it-6lc\/#%D8%A8%D8%A7_%D8%A7%D8%B3%D8%AA%D9%81%D8%A7%D8%AF%D9%87_%D8%A7%D8%B2_%D8%A7%DB%8C%D9%86_%D8%AF%D8%B1_WHERE_%D8%A8%D9%86%D8%AF%D9%87%D8%A7\" >\u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0627\u06cc\u0646 \u062f\u0631 WHERE \u0628\u0646\u062f\u0647\u0627<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/nabfollower.com\/blog\/mysql-using-json-data-and-not-hating-it-6lc\/#%DB%8C%DA%A9_%DA%A9%D9%84%D8%A7%DA%98_%D8%A8%D8%B1%D8%A7%DB%8C_%D8%B4%D8%A8%DB%8C%D9%87_%D8%B3%D8%A7%D8%B2%DB%8C_WHERE_IN_%D8%A8%D9%86%D8%AF%D9%87%D8%A7\" >\u06cc\u06a9 \u06a9\u0644\u0627\u0698 \u0628\u0631\u0627\u06cc \u0634\u0628\u06cc\u0647 \u0633\u0627\u0632\u06cc WHERE IN \u0628\u0646\u062f\u0647\u0627<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/nabfollower.com\/blog\/mysql-using-json-data-and-not-hating-it-6lc\/#%D8%B5%D8%A8%D8%B1_%DA%A9%D9%86_%D8%A7%DB%8C%D9%86_%DA%A9%D8%A7%D8%B1_%D9%85%DB%8C_%DA%A9%D9%86%D8%AF_TEXT_%D8%B3%D8%AA%D9%88%D9%86_%D9%87%D8%A7_%D9%87%D9%85%D8%9F\" >\u0635\u0628\u0631 \u06a9\u0646.  \u0627\u06cc\u0646 \u06a9\u0627\u0631 \u0645\u06cc \u06a9\u0646\u062f TEXT \u0633\u062a\u0648\u0646 \u0647\u0627 \u0647\u0645\u061f<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"%D8%A7%DB%8C%D8%AC%D8%A7%D8%AF_%DB%8C%DA%A9_JSON_%D8%B3%D8%AA%D9%88%D9%86\"><\/span>\n<p>  \u0627\u06cc\u062c\u0627\u062f \u06cc\u06a9 <code>JSON<\/code> \u0633\u062a\u0648\u0646<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0628\u06cc\u0627\u06cc\u06cc\u062f \u0628\u0627 \u0627\u06cc\u062c\u0627\u062f \u06cc\u06a9 \u062c\u062f\u0648\u0644 \u0628\u0627 \u06cc\u06a9 \u0633\u062a\u0648\u0646 \u0627\u0632 \u0646\u0648\u0639 \u0634\u0631\u0648\u0639 \u06a9\u0646\u06cc\u0645 <code>JSON<\/code>.<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"k\">CREATE<\/span> <span class=\"k\">TABLE<\/span> <span class=\"nv\">`some_data`<\/span> <span class=\"p\">(<\/span>\n  <span class=\"nv\">`id`<\/span> <span class=\"nb\">int<\/span> <span class=\"nb\">unsigned<\/span> <span class=\"k\">NOT<\/span> <span class=\"k\">NULL<\/span> <span class=\"n\">AUTO_INCREMENT<\/span><span class=\"p\">,<\/span>\n  <span class=\"nv\">`name`<\/span> <span class=\"nb\">varchar<\/span><span class=\"p\">(<\/span><span class=\"mi\">200<\/span><span class=\"p\">)<\/span> <span class=\"k\">NOT<\/span> <span class=\"k\">NULL<\/span><span class=\"p\">,<\/span>\n  <span class=\"nv\">`some_json`<\/span> <span class=\"n\">json<\/span> <span class=\"k\">NULL<\/span><span class=\"p\">,<\/span>\n  <span class=\"nv\">`some_text`<\/span> <span class=\"nb\">text<\/span> <span class=\"k\">NULL<\/span><span class=\"p\">,<\/span>\n  <span class=\"k\">PRIMARY<\/span> <span class=\"k\">KEY<\/span> <span class=\"p\">(<\/span><span class=\"nv\">`id`<\/span><span class=\"p\">)<\/span>\n<span class=\"p\">)<\/span> <span class=\"n\">ENGINE<\/span><span class=\"o\">=<\/span><span class=\"n\">InnoDB<\/span> <span class=\"k\">DEFAULT<\/span> <span class=\"n\">CHARSET<\/span><span class=\"o\">=<\/span><span class=\"n\">utf8mb4<\/span> <span class=\"k\">COLLATE<\/span><span class=\"o\">=<\/span><span class=\"n\">utf8mb4_unicode_ci<\/span><span class=\"p\">;<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u0622\u0632\u0645\u0627\u06cc\u0634\u06cc \u06a9\u0647 \u0642\u0631\u0627\u0631 \u0627\u0633\u062a \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u0645\u060c \u0646\u0645\u0627\u06cc\u0634 json \u062a\u06a9\u200c\u0622\u0647\u0646\u06af \u00ab\u0628\u0648\u0633 \u0648 \u0633\u0648\u0627\u0631\u00bb bratmobile \u0627\u0633\u062a.[https:\/\/www.discogs.com\/master\/409458-Bratmobile-Kiss-And-Ride].<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight json\"><code><span class=\"p\">{<\/span><span class=\"w\">\n  <\/span><span class=\"nl\">\"artist\"<\/span><span class=\"p\">:<\/span><span class=\"w\"> <\/span><span class=\"s2\">\"Bratmobile\"<\/span><span class=\"p\">,<\/span><span class=\"w\">\n  <\/span><span class=\"nl\">\"title\"<\/span><span class=\"p\">:<\/span><span class=\"w\"> <\/span><span class=\"s2\">\"Kiss and Ride\"<\/span><span class=\"p\">,<\/span><span class=\"w\">\n  <\/span><span class=\"nl\">\"format\"<\/span><span class=\"p\">:<\/span><span class=\"w\"> <\/span><span class=\"s2\">\"single\"<\/span><span class=\"p\">,<\/span><span class=\"w\">\n  <\/span><span class=\"nl\">\"year\"<\/span><span class=\"p\">:<\/span><span class=\"w\"> <\/span><span class=\"mi\">1992<\/span><span class=\"p\">,<\/span><span class=\"w\">\n  <\/span><span class=\"nl\">\"label\"<\/span><span class=\"p\">:<\/span><span class=\"w\"> <\/span><span class=\"s2\">\"Kill Rock Stars\"<\/span><span class=\"p\">,<\/span><span class=\"w\">\n  <\/span><span class=\"nl\">\"tracks\"<\/span><span class=\"p\">:<\/span><span class=\"w\"> <\/span><span class=\"p\">{<\/span><span class=\"w\">\n    <\/span><span class=\"nl\">\"A\"<\/span><span class=\"p\">:<\/span><span class=\"w\"> <\/span><span class=\"p\">[<\/span><span class=\"w\">\n      <\/span><span class=\"p\">{<\/span><span class=\"w\">\n        <\/span><span class=\"nl\">\"title\"<\/span><span class=\"p\">:<\/span><span class=\"w\"> <\/span><span class=\"s2\">\"Kiss and Ride\"<\/span><span class=\"p\">,<\/span><span class=\"w\">\n        <\/span><span class=\"nl\">\"duration_seconds\"<\/span><span class=\"p\">:<\/span><span class=\"w\"> <\/span><span class=\"mi\">88<\/span><span class=\"w\">\n      <\/span><span class=\"p\">}<\/span><span class=\"w\">\n    <\/span><span class=\"p\">],<\/span><span class=\"w\">\n    <\/span><span class=\"nl\">\"B\"<\/span><span class=\"p\">:<\/span><span class=\"w\"> <\/span><span class=\"p\">[<\/span><span class=\"w\">\n      <\/span><span class=\"p\">{<\/span><span class=\"w\">\n        <\/span><span class=\"nl\">\"title\"<\/span><span class=\"p\">:<\/span><span class=\"w\"> <\/span><span class=\"s2\">\"No You Don't\"<\/span><span class=\"p\">,<\/span><span class=\"w\">\n        <\/span><span class=\"nl\">\"duration_seconds\"<\/span><span class=\"p\">:<\/span><span class=\"w\"> <\/span><span class=\"mi\">105<\/span><span class=\"w\">\n      <\/span><span class=\"p\">},<\/span><span class=\"w\">\n      <\/span><span class=\"p\">{<\/span><span class=\"w\">\n        <\/span><span class=\"nl\">\"title\"<\/span><span class=\"p\">:<\/span><span class=\"w\"> <\/span><span class=\"s2\">\"Queenie\"<\/span><span class=\"p\">,<\/span><span class=\"w\">\n        <\/span><span class=\"nl\">\"duration_seconds\"<\/span><span class=\"p\">:<\/span><span class=\"w\"> <\/span><span class=\"mi\">79<\/span><span class=\"w\">\n      <\/span><span class=\"p\">}<\/span><span class=\"w\">\n    <\/span><span class=\"p\">]<\/span><span class=\"w\">\n  <\/span><span class=\"p\">}<\/span><span class=\"w\">\n<\/span><span class=\"p\">}<\/span><span class=\"w\">\n<\/span><\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0645\u0627 \u0622\u0646 json \u0631\u0627 \u062f\u0631 \u0647\u0631 \u062f\u0648 \u06cc\u06a9 Native \u0642\u0631\u0627\u0631 \u0645\u06cc \u062f\u0647\u06cc\u0645 <code>JSON<\/code> \u0633\u062a\u0648\u0646 \u0648 \u0647\u0645\u0686\u0646\u06cc\u0646 \u062f\u0631 a \u062a\u0627\u06cc\u067e \u06a9\u0646\u06cc\u062f <code>TEXT<\/code> \u0633\u062a\u0648\u0646  \u0628\u0639\u062f\u0627\u064b \u0628\u0647 \u0622\u0646 col \u0645\u062a\u0646 \u0628\u0627\u0632 \u062e\u0648\u0627\u0647\u06cc\u0645 \u06af\u0634\u062a.<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"k\">INSERT<\/span> <span class=\"k\">INTO<\/span> <span class=\"n\">some_data<\/span> <span class=\"k\">VALUES<\/span><span class=\"p\">(<\/span>\n  <span class=\"k\">null<\/span><span class=\"p\">,<\/span>\n  <span class=\"s1\">'some name'<\/span><span class=\"p\">,<\/span>\n  <span class=\"c1\">-- as json<\/span>\n  <span class=\"s1\">'{ \"artist\": \"Bratmobile\", \"title\": \"Kiss and Ride\", \"format\": \"single\", \"year\": 1992, \"label\": \"Kill Rock Stars\", \"tracks\": { \"A\": [ { \"title\": \"Kiss and Ride\", \"duration_seconds\": 88 } ], \"B\": [ { \"title\": \"No You Don<\/span><span class=\"se\">\\'<\/span><span class=\"s1\">t\", \"duration_seconds\": 105 }, { \"title\": \"Queenie\", \"duration_seconds\": 79 } ] } }'<\/span><span class=\"p\">,<\/span>\n  <span class=\"c1\">-- as string<\/span>\n  <span class=\"s1\">'{ \"artist\": \"Bratmobile\", \"title\": \"Kiss and Ride\", \"format\": \"single\", \"year\": 1992, \"label\": \"Kill Rock Stars\", \"tracks\": { \"A\": [ { \"title\": \"Kiss and Ride\", \"duration_seconds\": 88 } ], \"B\": [ { \"title\": \"No You Don<\/span><span class=\"se\">\\'<\/span><span class=\"s1\">t\", \"duration_seconds\": 105 }, { \"title\": \"Queenie\", \"duration_seconds\": 79 } ] } }'<\/span>\n<span class=\"p\">);<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"%D8%A7%D8%B3%D8%AA%D8%AE%D8%B1%D8%A7%D8%AC_%D8%A8%D8%B1%D8%AE%DB%8C_%D8%A7%D8%B2_%D8%AF%D8%A7%D8%AF%D9%87_%D9%87%D8%A7_%D8%A7%D8%B2_%D8%A2%D9%86_json\"><\/span>\n<p>  \u0627\u0633\u062a\u062e\u0631\u0627\u062c \u0628\u0631\u062e\u06cc \u0627\u0632 \u062f\u0627\u062f\u0647 \u0647\u0627 \u0627\u0632 \u0622\u0646 json<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0627\u06a9\u0646\u0648\u0646 \u06a9\u0647 \u0645\u0642\u062f\u0627\u0631\u06cc json \u062f\u0631 \u062e\u0648\u062f \u062f\u0627\u0631\u06cc\u0645 <code>JSON<\/code> \u0633\u062a\u0648\u0646\u060c \u0645\u0627 \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u0645 \u0631\u0648\u06cc \u0627\u0646\u062a\u062e\u0627\u0628 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0641\u0631\u062f\u06cc \u06a9\u0627\u0631 \u06a9\u0646\u06cc\u0645.  \u0645\u0627 \u0627\u06cc\u0646 \u06a9\u0627\u0631 \u0631\u0627 \u0628\u0627 mysql \u0627\u0646\u062c\u0627\u0645 \u0645\u06cc \u062f\u0647\u06cc\u0645 <code>JSON_EXTRACT<\/code> \u062a\u0627\u0628\u0639.<\/p>\n<p><code>JSON_EXTRACT<\/code>  \u062f\u0648 \u0622\u0631\u06af\u0648\u0645\u0627\u0646 \u0645\u06cc \u06af\u06cc\u0631\u062f: \u0633\u062a\u0648\u0646 \u0648 \u0645\u0633\u06cc\u0631 \u0639\u0646\u0635\u0631\u06cc \u06a9\u0647 \u0645\u06cc \u062e\u0648\u0627\u0647\u06cc\u062f \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0646\u06cc\u062f.  \u0645\u0633\u06cc\u0631\u0647\u0627 \u0628\u0627 \u06cc\u06a9 \u0646\u0642\u0637\u0647 \u0627\u0632 \u0647\u0645 \u062c\u062f\u0627 \u0645\u06cc \u0634\u0648\u0646\u062f\u060c \u0628\u0647 \u0647\u0645\u0627\u0646 \u0631\u0648\u0634\u06cc \u06a9\u0647 \u0645\u0633\u06cc\u0631\u0647\u0627\u06cc \u062f\u0627\u06cc\u0631\u06a9\u062a\u0648\u0631\u06cc \u0628\u0627 a \u062c\u062f\u0627 \u0645\u06cc \u0634\u0648\u0646\u062f <code>\/<\/code>\u060c \u0648 \u0633\u0637\u062d \u0628\u0627\u0644\u0627\u06cc \u0645\u0633\u06cc\u0631 \u0628\u0627 \u0646\u0634\u0627\u0646 \u062f\u0627\u062f\u0647 \u0645\u06cc \u0634\u0648\u062f <code>$<\/code>.  \u0627\u06af\u0631 \u062a\u0627 \u0628\u0647 \u062d\u0627\u0644 \u0628\u0627 \u0622\u0646 \u0645\u0628\u0627\u0631\u0632\u0647 \u06a9\u0631\u062f\u0647 \u0627\u06cc\u062f <code>jq<\/code>\u060c \u0628\u0627\u06cc\u062f \u0627\u062d\u0633\u0627\u0633 \u0631\u0627\u062d\u062a\u06cc \u06a9\u0646\u06cc\u062f \u06a9\u0647 \u0628\u0627 \u0627\u06cc\u0646 \u062f\u0633\u062a \u0648 \u067e\u0646\u062c\u0647 \u0646\u0631\u0645 \u06a9\u0646\u06cc\u062f.<\/p>\n<p>\u062f\u0631 \u0627\u06cc\u0646 \u0645\u062b\u0627\u0644\u060c \u0645\u0627 \u0631\u0627 \u0627\u0646\u062a\u062e\u0627\u0628 \u0645\u06cc \u06a9\u0646\u06cc\u0645 <code>artist<\/code> \u0639\u0646\u0635\u0631 \u0627\u0632 \u0633\u0637\u062d \u0628\u0627\u0644\u0627\u06cc \u0634\u06cc json \u0645\u0627.<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"k\">SELECT<\/span>  <span class=\"n\">JSON_EXTRACT<\/span><span class=\"p\">(<\/span><span class=\"n\">some_json<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'$.artist'<\/span><span class=\"p\">)<\/span> <span class=\"k\">as<\/span> <span class=\"n\">artist<\/span>\n<span class=\"k\">FROM<\/span>    <span class=\"n\">some_data<\/span>\n<span class=\"k\">WHERE<\/span>   <span class=\"n\">id<\/span> <span class=\"o\">=<\/span> <span class=\"mi\">1<\/span><span class=\"p\">;<\/span>\n<span class=\"o\">+<\/span><span class=\"c1\">--------------+<\/span>\n<span class=\"o\">|<\/span> <span class=\"n\">artist<\/span>       <span class=\"o\">|<\/span>\n<span class=\"o\">+<\/span><span class=\"c1\">--------------+<\/span>\n<span class=\"o\">|<\/span> <span class=\"nv\">\"Bratmobile\"<\/span> <span class=\"o\">|<\/span>\n<span class=\"o\">+<\/span><span class=\"c1\">--------------+<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>mysql \u0646\u06cc\u0632 \u0641\u0631\u0627\u0647\u0645 \u0645\u06cc \u06a9\u0646\u062f <code>-&gt;<\/code> \u0639\u0645\u0644\u06af\u0631 \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0645\u062e\u0641\u0641 <code>JSON_EXTRACT<\/code> \u06a9\u0645\u06a9 \u06a9\u0646\u062f \u062a\u0627 \u0633\u0648\u0627\u0644\u0627\u062a \u0645\u0627 \u06a9\u0645\u06cc \u062a\u0645\u06cc\u0632\u062a\u0631 \u0634\u0648\u062f.<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"k\">SELECT<\/span>  <span class=\"n\">some_json<\/span> <span class=\"o\">-&gt;<\/span> <span class=\"s1\">'$.artist'<\/span> <span class=\"k\">as<\/span> <span class=\"n\">artist<\/span>\n<span class=\"k\">FROM<\/span>    <span class=\"n\">some_data<\/span>\n<span class=\"k\">WHERE<\/span>   <span class=\"n\">id<\/span> <span class=\"o\">=<\/span> <span class=\"mi\">1<\/span><span class=\"p\">;<\/span>\n<span class=\"o\">+<\/span><span class=\"c1\">--------------+<\/span>\n<span class=\"o\">|<\/span> <span class=\"n\">artist<\/span>       <span class=\"o\">|<\/span>\n<span class=\"o\">+<\/span><span class=\"c1\">--------------+<\/span>\n<span class=\"o\">|<\/span> <span class=\"nv\">\"Bratmobile\"<\/span> <span class=\"o\">|<\/span>\n<span class=\"o\">+<\/span><span class=\"c1\">--------------+<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0645\u0632\u0627\u062d\u0645\u062a\u06cc \u06a9\u0647 \u0628\u0644\u0627\u0641\u0627\u0635\u0644\u0647 \u0628\u0627 \u0627\u06cc\u0646 \u0646\u062a\u0627\u06cc\u062c \u0645\u062a\u0648\u062c\u0647 \u0645\u06cc\u200c\u0634\u0648\u06cc\u0645 \u0627\u06cc\u0646 \u0627\u0633\u062a \u06a9\u0647 \u0622\u0646\u0647\u0627 \u0628\u0647 \u0635\u0648\u0631\u062a \u0646\u0642\u0644 \u0642\u0648\u0644 \u0647\u0633\u062a\u0646\u062f.  \u0645\u0627 \u0627\u06cc\u0646 \u0631\u0627 \u0646\u0645\u06cc \u062e\u0648\u0627\u0647\u06cc\u0645  \u0647\u06cc\u0686 \u06a9\u0633 \u0627\u06cc\u0646 \u0631\u0627 \u0646\u0645\u06cc \u062e\u0648\u0627\u0647\u062f  \u0627\u062c\u0627\u0632\u0647 \u062f\u0647\u06cc\u062f \u0622\u0646\u0647\u0627 \u0631\u0627 \u0628\u0627 \u062a\u0627\u0628\u0639 \u062d\u0630\u0641 \u06a9\u0646\u06cc\u0645 <code>JSON_UNQUOTE<\/code><\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"k\">SELECT<\/span>  <span class=\"n\">JSON_UNQUOTE<\/span><span class=\"p\">(<\/span><span class=\"n\">JSON_EXTRACT<\/span><span class=\"p\">(<\/span><span class=\"n\">some_json<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'$.artist'<\/span><span class=\"p\">))<\/span> <span class=\"k\">as<\/span> <span class=\"n\">artist<\/span>\n<span class=\"k\">FROM<\/span>    <span class=\"n\">some_data<\/span>\n<span class=\"k\">WHERE<\/span>   <span class=\"n\">id<\/span> <span class=\"o\">=<\/span> <span class=\"mi\">1<\/span><span class=\"p\">;<\/span>\n<span class=\"o\">+<\/span><span class=\"c1\">------------+<\/span>\n<span class=\"o\">|<\/span> <span class=\"n\">artist<\/span>     <span class=\"o\">|<\/span>\n<span class=\"o\">+<\/span><span class=\"c1\">------------+<\/span>\n<span class=\"o\">|<\/span> <span class=\"n\">Bratmobile<\/span> <span class=\"o\">|<\/span>\n<span class=\"o\">+<\/span><span class=\"c1\">------------+<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u06a9\u0648\u062a\u0627\u0647 \u0646\u0648\u06cc\u0633\u06cc <code>-&gt;<\/code> \u0639\u0645\u0644\u06af\u0631\u06cc \u06a9\u0647 \u0642\u0628\u0644\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0631\u062f\u06cc\u0645 \u0631\u0627 \u0645\u06cc \u062a\u0648\u0627\u0646 \u0628\u0647 \u0622\u0646 \u062a\u063a\u06cc\u06cc\u0631 \u062f\u0627\u062f <code>-&gt;&gt;<\/code> \u0628\u0647 \u0637\u0648\u0631 \u062e\u0648\u062f\u06a9\u0627\u0631 \u0634\u0627\u0645\u0644 \u0634\u0648\u062f <code>JSON_UNQUOTE<\/code>.  \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0627\u06cc\u0646 \u0627\u067e\u0631\u0627\u062a\u0648\u0631 \u0645\u0627\u0646\u0646\u062f \u0645\u062d\u0635\u0648\u0631 \u06a9\u0631\u062f\u0646 \u06cc\u06a9 \u062a\u0645\u0627\u0633 \u0627\u0633\u062a <code>JSON_EXTRACT<\/code> \u06a9\u0647 \u062f\u0631 <code>JSON_UNQUOTE<\/code>:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"k\">SELECT<\/span>  <span class=\"n\">some_json<\/span> <span class=\"o\">-&gt;&gt;<\/span> <span class=\"s1\">'$.artist'<\/span> <span class=\"k\">as<\/span> <span class=\"n\">artist<\/span>\n<span class=\"k\">FROM<\/span>    <span class=\"n\">some_data<\/span>\n<span class=\"k\">WHERE<\/span>   <span class=\"n\">id<\/span> <span class=\"o\">=<\/span> <span class=\"mi\">1<\/span><span class=\"p\">;<\/span>\n<span class=\"o\">+<\/span><span class=\"c1\">------------+<\/span>\n<span class=\"o\">|<\/span> <span class=\"n\">artist<\/span>     <span class=\"o\">|<\/span>\n<span class=\"o\">+<\/span><span class=\"c1\">------------+<\/span>\n<span class=\"o\">|<\/span> <span class=\"n\">Bratmobile<\/span> <span class=\"o\">|<\/span>\n<span class=\"o\">+<\/span><span class=\"c1\">------------+<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"%D8%A8%D8%B1%D8%AE%D9%88%D8%B1%D8%AF_%D8%A8%D8%A7_%D8%A2%D8%B1%D8%A7%DB%8C%D9%87_%D9%87%D8%A7\"><\/span>\n<p>  \u0628\u0631\u062e\u0648\u0631\u062f \u0628\u0627 \u0622\u0631\u0627\u06cc\u0647 \u0647\u0627<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u06af\u0631\u0641\u062a\u0646 \u0639\u0646\u0627\u0635\u0631 \u0645\u0646\u0641\u0631\u062f \u0627\u0632 \u0633\u0637\u062d \u0628\u0627\u0644\u0627 \u0639\u0627\u0644\u06cc \u0627\u0633\u062a\u060c \u0627\u0645\u0627 \u0645\u0627 \u0647\u0645\u0686\u0646\u06cc\u0646 \u0645\u06cc \u062e\u0648\u0627\u0647\u06cc\u0645 \u0628\u0627 \u0622\u0631\u0627\u06cc\u0647 \u0647\u0627 \u0633\u0631 \u0648 \u06a9\u0627\u0631 \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u0645.<\/p>\n<p>\u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u0645 \u062f\u0631 \u0645\u0633\u06cc\u0631\u06cc \u06a9\u0647 \u0628\u0647 \u0622\u0646 \u067e\u0627\u0633 \u0645\u06cc \u062f\u0647\u06cc\u0645 \u0628\u0647 \u0622\u0631\u0627\u06cc\u0647 \u0647\u0627 \u0627\u0631\u062c\u0627\u0639 \u062f\u0647\u06cc\u0645 <code>JSON_EXTRACT<\/code> \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u06cc\u06a9 \u0634\u0627\u062e\u0635 \u062f\u0631 \u062f\u0627\u062e\u0644 \u067e\u0631\u0627\u0646\u062a\u0632.  \u0627\u06cc\u0646 \u0686\u06cc\u0632\u0647\u0627\u06cc \u0628\u0633\u06cc\u0627\u0631 \u0622\u0634\u0646\u0627 \u0627\u0633\u062a  \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0645\u062b\u0627\u0644\u060c \u062f\u0631 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0646\u0645\u0648\u0646\u0647 \u062e\u0648\u062f\u060c \u06cc\u06a9 \u0634\u06cc \u062f\u0627\u0631\u06cc\u0645 \u06a9\u0647 \u0628\u0647 \u0622\u0646 \u0646\u0627\u0645\u06cc\u062f\u0647 \u0645\u06cc \u0634\u0648\u062f <code>tracks<\/code> \u06a9\u0647 \u0634\u0627\u0645\u0644 \u062f\u0648 \u0622\u0631\u0627\u06cc\u0647 \u0627\u0633\u062a \u06a9\u0647 \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u06a9\u0644\u06cc\u062f \u0634\u062f\u0647 \u0627\u0633\u062a <code>A<\/code> \u0648 <code>B<\/code>;  \u0627\u06cc\u0646 \u0647\u0627 \u0622\u0647\u0646\u06af \u0647\u0627\u06cc \u0637\u0631\u0641 &#8220;a&#8221; \u0648 &#8220;b&#8221; \u0647\u0633\u062a\u0646\u062f.  \u0622\u0646 \u0647\u0627 <code>A<\/code> \u0648 <code>B<\/code> \u0639\u0646\u0627\u0635\u0631 \u0622\u0631\u0627\u06cc\u0647 \u0647\u0627\u06cc\u06cc \u0627\u0632 \u0627\u0634\u06cc\u0627\u0621 \u0622\u0647\u0646\u06af \u0647\u0633\u062a\u0646\u062f.  \u0627\u06af\u0631 \u0645\u06cc \u062e\u0648\u0627\u0633\u062a\u06cc\u0645 \u0627\u0648\u0644\u06cc\u0646 \u0622\u0647\u0646\u06af \u0633\u0627\u06cc\u062f \u0631\u0627 \u0628\u06af\u06cc\u0631\u06cc\u0645 <code>B<\/code>\u060c \u0645\u0627 \u062e\u0648\u062f \u0631\u0627 \u0645\u06cc \u0633\u0627\u0632\u06cc\u0645 <code>JSON_EXTRACT<\/code> \u0627\u06cc\u0646\u0637\u0648\u0631\u06cc \u0632\u0646\u06af \u0628\u0632\u0646:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"k\">SELECT<\/span>  <span class=\"n\">JSON_EXTRACT<\/span><span class=\"p\">(<\/span><span class=\"n\">some_json<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'$.tracks.B[0].title'<\/span><span class=\"p\">)<\/span> <span class=\"k\">as<\/span> <span class=\"n\">side_b_song_one<\/span>\n<span class=\"k\">FROM<\/span>    <span class=\"n\">some_data<\/span>\n<span class=\"k\">WHERE<\/span>   <span class=\"n\">id<\/span> <span class=\"o\">=<\/span> <span class=\"mi\">1<\/span><span class=\"p\">;<\/span>\n<span class=\"o\">+<\/span><span class=\"c1\">-----------------+<\/span>\n<span class=\"o\">|<\/span> <span class=\"n\">side_b_song_one<\/span> <span class=\"o\">|<\/span>\n<span class=\"o\">+<\/span><span class=\"c1\">-----------------+<\/span>\n<span class=\"o\">|<\/span> <span class=\"nv\">\"No You Don't\"<\/span>  <span class=\"o\">|<\/span>\n<span class=\"o\">+<\/span><span class=\"c1\">-----------------+<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0628\u0627 \u0646\u06af\u0627\u0647 \u06a9\u0631\u062f\u0646 \u0628\u0647 \u0622\u0631\u06af\u0648\u0645\u0627\u0646 \u0645\u0633\u06cc\u0631\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u0645 \u0628\u0628\u06cc\u0646\u06cc\u0645 \u06a9\u0647 \u0627\u0632 \u0628\u0627\u0644\u0627\u06cc \u0633\u0644\u0633\u0644\u0647 \u0645\u0631\u0627\u062a\u0628 \u0634\u0631\u0648\u0639 \u0645\u06cc\u200c\u06a9\u0646\u06cc\u0645 <code>$<\/code>\u060c \u0633\u067e\u0633 \u0628\u0647 <code>tracks<\/code> \u0647\u062f\u0641 &#8211; \u0634\u06cc.  \u0628\u0639\u062f\u06cc \u0622\u0631\u0627\u06cc\u0647 \u0627\u0633\u062a <code>B<\/code>.  \u0646\u0634\u0627\u0646 \u0645\u06cc \u062f\u0647\u06cc\u0645 \u06a9\u0647 \u0627\u0648\u0644\u06cc\u0646 \u0639\u0646\u0635\u0631 \u0627\u06cc\u0646 \u0622\u0631\u0627\u06cc\u0647 \u0631\u0627 \u0628\u0627 \u0622\u0646 \u0645\u06cc \u062e\u0648\u0627\u0647\u06cc\u0645 <code>[0]<\/code>\u060c \u0633\u067e\u0633 \u0628\u0627 \u062f\u0627\u062f\u0646 \u06a9\u0644\u06cc\u062f \u0645\u0633\u06cc\u0631 \u062e\u0648\u062f \u0631\u0627 \u0627\u062f\u0627\u0645\u0647 \u062f\u0647\u06cc\u062f <code>title<\/code>.  \u0646\u062a\u06cc\u062c\u0647 \u0639\u0646\u0648\u0627\u0646 \u0627\u0648\u0644\u06cc\u0646 \u0622\u0647\u0646\u06af \u0633\u0645\u062a b \u0627\u0633\u062a.<\/p>\n<p>\u0627\u06af\u0631 \u0645\u0627 \u0628\u062e\u0648\u0627\u0647\u06cc\u0645 <em>\u0647\u0645\u0647<\/em> \u0622\u0647\u0646\u06af \u0647\u0627\u06cc \u0633\u0645\u062a b\u060c \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u0645 \u0622\u0646 \u0634\u0627\u062e\u0635 \u0631\u0627 \u0628\u0627 \u0639\u0644\u0627\u0645\u062a \u0639\u0627\u0645 \u062c\u0627\u06cc\u06af\u0632\u06cc\u0646 \u06a9\u0646\u06cc\u0645 <code>*<\/code>.  \u0627\u06cc\u0646 \u06cc\u06a9 \u0622\u0631\u0627\u06cc\u0647 json \u0627\u0632 \u0639\u0646\u0627\u0648\u06cc\u0646 \u0631\u0627 \u0628\u0631\u0645\u06cc \u06af\u0631\u062f\u0627\u0646\u062f.<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"k\">SELECT<\/span>  <span class=\"n\">JSON_EXTRACT<\/span><span class=\"p\">(<\/span><span class=\"n\">some_json<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'$.tracks.B[*].title'<\/span><span class=\"p\">)<\/span> <span class=\"k\">as<\/span> <span class=\"n\">side_b<\/span>\n<span class=\"k\">FROM<\/span>    <span class=\"n\">some_data<\/span>\n<span class=\"k\">WHERE<\/span>   <span class=\"n\">id<\/span> <span class=\"o\">=<\/span> <span class=\"mi\">1<\/span><span class=\"p\">;<\/span>\n<span class=\"o\">+<\/span><span class=\"c1\">-----------------------------+<\/span>\n<span class=\"o\">|<\/span> <span class=\"n\">side_b<\/span>                      <span class=\"o\">|<\/span>\n<span class=\"o\">+<\/span><span class=\"c1\">-----------------------------+<\/span>\n<span class=\"o\">|<\/span> <span class=\"p\">[<\/span><span class=\"nv\">\"No You Don't\"<\/span><span class=\"p\">,<\/span> <span class=\"nv\">\"Queenie\"<\/span><span class=\"p\">]<\/span> <span class=\"o\">|<\/span>\n<span class=\"o\">+<\/span><span class=\"c1\">-----------------------------+<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0645\u0627 \u0647\u0645\u0686\u0646\u06cc\u0646 \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u0645 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u0645 <code>**<\/code> wildcard \u0628\u0631\u0627\u06cc \u0627\u0646\u062c\u0627\u0645 \u0627\u06cc\u0646 \u06a9\u0627\u0631.<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"k\">SELECT<\/span>  <span class=\"n\">JSON_EXTRACT<\/span><span class=\"p\">(<\/span><span class=\"n\">some_json<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'$.tracks.B**.title'<\/span><span class=\"p\">)<\/span> <span class=\"k\">as<\/span> <span class=\"n\">side_b<\/span>\n<span class=\"k\">FROM<\/span>    <span class=\"n\">some_data<\/span>\n<span class=\"k\">WHERE<\/span>   <span class=\"n\">id<\/span> <span class=\"o\">=<\/span> <span class=\"mi\">1<\/span><span class=\"p\">;<\/span>\n<span class=\"o\">+<\/span><span class=\"c1\">-----------------------------+<\/span>\n<span class=\"o\">|<\/span> <span class=\"n\">side_b<\/span>                      <span class=\"o\">|<\/span>\n<span class=\"o\">+<\/span><span class=\"c1\">-----------------------------+<\/span>\n<span class=\"o\">|<\/span> <span class=\"p\">[<\/span><span class=\"nv\">\"No You Don't\"<\/span><span class=\"p\">,<\/span> <span class=\"nv\">\"Queenie\"<\/span><span class=\"p\">]<\/span> <span class=\"o\">|<\/span>\n<span class=\"o\">+<\/span><span class=\"c1\">-----------------------------+<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0645\u0647\u0645 \u0627\u0633\u062a \u06a9\u0647 \u062a\u0648\u062c\u0647 \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u062f <code>**<\/code> \u062f\u0631 \u0648\u0627\u0642\u0639 \u06cc\u0639\u0646\u06cc <em>\u0647\u0645\u0647<\/em> \u0645\u0633\u06cc\u0631\u0647\u0627\u06cc \u0628\u06cc\u0646 \u067e\u06cc\u0634\u0648\u0646\u062f \u0648 \u067e\u0633\u0648\u0646\u062f.  \u0627\u06cc\u0646 \u0628\u062f\u0627\u0646 \u0645\u0639\u0646\u06cc \u0627\u0633\u062a \u06a9\u0647 \u0645\u0627 \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u0645 \u0627\u0632 \u0622\u0646 \u0628\u0631\u0627\u06cc \u062f\u0631\u06cc\u0627\u0641\u062a \u0647\u0645\u0647 \u0645\u0648\u0627\u0631\u062f \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u0645 <code>title<\/code> \u0639\u0646\u0627\u0635\u0631 \u0632\u06cc\u0631 <code>tracks<\/code>\u060c \u0635\u0631\u0641 \u0646\u0638\u0631 \u0627\u0632 \u0627\u06cc\u0646\u06a9\u0647 \u0622\u06cc\u0627 \u062f\u0631 \u0622\u0631\u0627\u06cc\u0647 \u06a9\u0644\u06cc\u062f \u062e\u0648\u0631\u062f\u0647 \u0627\u0633\u062a \u06cc\u0627 \u062e\u06cc\u0631 <code>A<\/code> \u06cc\u0627 <code>B<\/code> \u0645\u0627\u0646\u0646\u062f:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"k\">SELECT<\/span>  <span class=\"n\">JSON_EXTRACT<\/span><span class=\"p\">(<\/span><span class=\"n\">some_json<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'$.tracks**.title'<\/span><span class=\"p\">)<\/span> <span class=\"k\">as<\/span> <span class=\"n\">side_a_and_side_be<\/span>\n<span class=\"k\">FROM<\/span>    <span class=\"n\">some_data<\/span>\n<span class=\"k\">WHERE<\/span>   <span class=\"n\">id<\/span> <span class=\"o\">=<\/span> <span class=\"mi\">1<\/span><span class=\"p\">;<\/span>\n<span class=\"o\">+<\/span><span class=\"c1\">----------------------------------------------+<\/span>\n<span class=\"o\">|<\/span> <span class=\"n\">side_a_and_side_be<\/span>                           <span class=\"o\">|<\/span>\n<span class=\"o\">+<\/span><span class=\"c1\">----------------------------------------------+<\/span>\n<span class=\"o\">|<\/span> <span class=\"p\">[<\/span><span class=\"nv\">\"Kiss and Ride\"<\/span><span class=\"p\">,<\/span> <span class=\"nv\">\"No You Don't\"<\/span><span class=\"p\">,<\/span> <span class=\"nv\">\"Queenie\"<\/span><span class=\"p\">]<\/span> <span class=\"o\">|<\/span>\n<span class=\"o\">+<\/span><span class=\"c1\">----------------------------------------------+<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u062f\u0631 \u0622\u0646 \u0645\u062b\u0627\u0644\u060c <code>**<\/code> \u0628\u0627 \u0647\u0631 \u062f\u0648 \u0645\u0637\u0627\u0628\u0642\u062a \u062f\u0627\u0631\u062f <code>A<\/code> \u0648 <code>B<\/code>.  \u0686\u06cc\u0632\u0647\u0627\u06cc \u0628\u0633\u06cc\u0627\u0631 \u0642\u062f\u0631\u062a\u0645\u0646\u062f<\/p>\n<p>\u0645\u0627 \u0647\u0645\u0686\u0646\u06cc\u0646 \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u0645 \u062f\u0631 \u0647\u0646\u06af\u0627\u0645 \u062a\u0639\u0631\u06cc\u0641 \u0634\u0627\u062e\u0635 \u0647\u0627\u06cc \u0622\u0631\u0627\u06cc\u0647 \u062e\u0648\u062f \u0627\u0632 \u0645\u062d\u062f\u0648\u062f\u0647 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u0645.  \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0645\u062b\u0627\u0644\u060c \u0627\u06af\u0631 \u0645\u0627 \u0645\u06cc \u062e\u0648\u0627\u0633\u062a\u06cc\u0645 \u0647\u0645\u0647 \u0631\u0627 \u0628\u062f\u0633\u062a \u0622\u0648\u0631\u06cc\u0645 <code>title<\/code>\u062f\u0631 \u06a9\u0646\u0627\u0631 <code>B<\/code> \u0628\u06cc\u0646 \u0645\u0648\u0642\u0639\u06cc\u062a \u0635\u0641\u0631 \u0648 \u06cc\u06a9\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u0645 \u0627\u0632 \u0634\u0627\u062e\u0635 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u0645 <code>[0 to 1]<\/code>:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"k\">SELECT<\/span>  <span class=\"n\">JSON_EXTRACT<\/span><span class=\"p\">(<\/span><span class=\"n\">some_json<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'$.tracks.B[0 to 1].title'<\/span><span class=\"p\">)<\/span> <span class=\"k\">as<\/span> <span class=\"n\">side_b_first_two<\/span>\n<span class=\"k\">FROM<\/span>    <span class=\"n\">some_data<\/span>\n<span class=\"k\">WHERE<\/span>   <span class=\"n\">id<\/span> <span class=\"o\">=<\/span> <span class=\"mi\">1<\/span><span class=\"p\">;<\/span>\n<span class=\"o\">+<\/span><span class=\"c1\">-----------------------------+<\/span>\n<span class=\"o\">|<\/span> <span class=\"n\">side_b_first_two<\/span>            <span class=\"o\">|<\/span>\n<span class=\"o\">+<\/span><span class=\"c1\">-----------------------------+<\/span>\n<span class=\"o\">|<\/span> <span class=\"p\">[<\/span><span class=\"nv\">\"No You Don't\"<\/span><span class=\"p\">,<\/span> <span class=\"nv\">\"Queenie\"<\/span><span class=\"p\">]<\/span> <span class=\"o\">|<\/span>\n<span class=\"o\">+<\/span><span class=\"c1\">-----------------------------+<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0648 \u0627\u06af\u0631 \u062a\u0646\u0647\u0627 \u0686\u06cc\u0632\u06cc \u06a9\u0647 \u0645\u06cc \u062e\u0648\u0627\u0647\u06cc\u0645 \u0622\u062e\u0631\u06cc\u0646 \u0639\u0646\u0635\u0631 \u06cc\u06a9 \u0622\u0631\u0627\u06cc\u0647 \u0628\u0627\u0634\u062f\u060c mysql \u0628\u0647 \u0645\u0627 \u0627\u062c\u0627\u0632\u0647 \u0645\u06cc \u062f\u0647\u062f \u0627\u0632 \u06a9\u0644\u0645\u0647 \u062a\u062d\u062a \u0627\u0644\u0644\u0641\u0638\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u0645 <code>last<\/code>:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"k\">SELECT<\/span>  <span class=\"n\">JSON_EXTRACT<\/span><span class=\"p\">(<\/span><span class=\"n\">some_json<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'$.tracks.B[last].title'<\/span><span class=\"p\">)<\/span> <span class=\"k\">as<\/span> <span class=\"n\">side_b_last_track<\/span>\n<span class=\"k\">FROM<\/span>    <span class=\"n\">some_data<\/span>\n<span class=\"k\">WHERE<\/span>   <span class=\"n\">id<\/span> <span class=\"o\">=<\/span> <span class=\"mi\">1<\/span><span class=\"p\">;<\/span>\n<span class=\"o\">+<\/span><span class=\"c1\">-------------------+<\/span>\n<span class=\"o\">|<\/span> <span class=\"n\">side_b_last_track<\/span> <span class=\"o\">|<\/span>\n<span class=\"o\">+<\/span><span class=\"c1\">-------------------+<\/span>\n<span class=\"o\">|<\/span> <span class=\"nv\">\"Queenie\"<\/span>         <span class=\"o\">|<\/span>\n<span class=\"o\">+<\/span><span class=\"c1\">-------------------+<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"%D8%A8%D8%A7_%D8%A7%D8%B3%D8%AA%D9%81%D8%A7%D8%AF%D9%87_%D8%A7%D8%B2_%D8%A7%DB%8C%D9%86_%D8%AF%D8%B1_WHERE_%D8%A8%D9%86%D8%AF%D9%87%D8%A7\"><\/span>\n<p>  \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0627\u06cc\u0646 \u062f\u0631 <code>WHERE<\/code> \u0628\u0646\u062f\u0647\u0627<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0627\u0633\u062a\u062e\u0631\u0627\u062c \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0627\u0632 json \u0645\u0641\u06cc\u062f \u0627\u0633\u062a\u060c \u0627\u0645\u0627 \u062f\u0631 \u0648\u0627\u0642\u0639\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u0645 \u06a9\u0644 \u0633\u062a\u0648\u0646 \u0631\u0627 \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0631\u062f\u0647 \u0648 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0631\u0627 \u0627\u062c\u0631\u0627 \u06a9\u0646\u06cc\u0645 <code>json_decode<\/code> \u062f\u0631 \u06a9\u0646\u062a\u0631\u0644 \u06a9\u0646\u0646\u062f\u0647 \u0645\u0627  \u0631\u0627 <em>\u0648\u0627\u0642\u0639\u06cc<\/em> \u067e\u0648\u0644 \u0627\u0632 \u0627\u06cc\u0646 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u06a9\u0646\u062f <code>WHERE<\/code> \u0628\u0646\u062f\u0647\u0627  \u0628\u06cc\u0627\u06cc\u06cc\u062f \u0646\u06af\u0627\u0647 \u0628\u06cc\u0646\u062f\u0627\u0632\u06cc\u0645:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"k\">SELECT<\/span>  <span class=\"n\">JSON_EXTRACT<\/span><span class=\"p\">(<\/span><span class=\"n\">some_json<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'$.title'<\/span><span class=\"p\">)<\/span> <span class=\"k\">as<\/span> <span class=\"n\">title<\/span>\n<span class=\"k\">FROM<\/span>    <span class=\"n\">some_data<\/span>\n<span class=\"k\">WHERE<\/span>   <span class=\"n\">JSON_EXTRACT<\/span><span class=\"p\">(<\/span><span class=\"n\">some_json<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'$.year'<\/span><span class=\"p\">)<\/span> <span class=\"o\">=<\/span> <span class=\"mi\">1992<\/span><span class=\"p\">;<\/span>\n<span class=\"o\">+<\/span><span class=\"c1\">-----------------+<\/span>\n<span class=\"o\">|<\/span> <span class=\"n\">title<\/span>           <span class=\"o\">|<\/span>\n<span class=\"o\">+<\/span><span class=\"c1\">-----------------+<\/span>\n<span class=\"o\">|<\/span> <span class=\"nv\">\"Kiss and Ride\"<\/span> <span class=\"o\">|<\/span>\n<span class=\"o\">+<\/span><span class=\"c1\">-----------------+<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u062f\u0631 \u0627\u06cc\u0646\u062c\u0627 \u0645\u0627 \u0641\u0642\u0637 \u0627\u0633\u062a\u062e\u0631\u0627\u062c \u06a9\u0631\u062f\u06cc\u0645 <code>year<\/code> \u0627\u0632 \u0633\u062a\u0648\u0646 json \u0645\u0627 \u0648 \u062f\u0631 a \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u0634\u0648\u062f <code>WHERE<\/code> \u0639\u0628\u0627\u0631\u062a.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"%DB%8C%DA%A9_%DA%A9%D9%84%D8%A7%DA%98_%D8%A8%D8%B1%D8%A7%DB%8C_%D8%B4%D8%A8%DB%8C%D9%87_%D8%B3%D8%A7%D8%B2%DB%8C_WHERE_IN_%D8%A8%D9%86%D8%AF%D9%87%D8%A7\"><\/span>\n<p>  \u06cc\u06a9 \u06a9\u0644\u0627\u0698 \u0628\u0631\u0627\u06cc \u0634\u0628\u06cc\u0647 \u0633\u0627\u0632\u06cc <code>WHERE IN<\/code> \u0628\u0646\u062f\u0647\u0627<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0627\u06af\u0631 \u0628\u062e\u0648\u0627\u0647\u06cc\u0645 \u0627\u0644\u0641 \u0628\u0646\u0648\u06cc\u0633\u06cc\u0645 <code>WHERE IN<\/code> \u0628\u0646\u062f \u062f\u0631 \u0628\u0631\u0627\u0628\u0631 \u06cc\u06a9 \u0622\u0631\u0627\u06cc\u0647 \u062f\u0631 \u0634\u06cc json \u0645\u0627\u060c \u0647\u0645\u0647 \u0686\u06cc\u0632 \u06a9\u0645\u06cc \u067e\u06cc\u0686\u06cc\u062f\u0647 \u062a\u0631 \u0645\u06cc \u0634\u0648\u062f.  \u0627\u06cc\u062f\u0647 \u0622\u0644 \u0627\u0648\u0644\u06cc\u0647 \u0645\u0627 \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u0627\u06cc\u0646 \u0628\u0627\u0634\u062f \u06a9\u0647 \u0628\u0647 \u0633\u0627\u062f\u06af\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u0645 <code>IN<\/code> \u062f\u0631 \u06cc\u06a9 \u0622\u0631\u0627\u06cc\u0647 \u0627\u0633\u062a\u062e\u0631\u0627\u062c \u0634\u062f\u0647 \u0627\u0632 json \u0645\u0627:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"c1\">-- this absolutely DOES NOT WORK<\/span>\n<span class=\"k\">SELECT<\/span>  <span class=\"n\">JSON_EXTRACT<\/span><span class=\"p\">(<\/span><span class=\"n\">some_json<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'$.title'<\/span><span class=\"p\">)<\/span> <span class=\"k\">as<\/span> <span class=\"n\">title<\/span>\n<span class=\"k\">FROM<\/span>    <span class=\"n\">some_data<\/span>\n<span class=\"k\">WHERE<\/span>   <span class=\"nv\">\"No You Don't\"<\/span> <span class=\"k\">IN<\/span> <span class=\"n\">JSON_EXTRACT<\/span><span class=\"p\">(<\/span><span class=\"n\">some_json<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'$.tracks**.title'<\/span><span class=\"p\">);<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0628\u062f\u0648\u0646 \u062a\u0627\u0633.  \u0627\u0644\u0628\u062a\u0647 \u0645\u0634\u06a9\u0644 \u0627\u06cc\u0646\u062c\u0627\u0633\u062a \u06a9\u0647 <code>WHERE IN<\/code> \u0644\u06cc\u0633\u062a\u06cc \u0627\u0632 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0631\u0627 \u0627\u0646\u062a\u0638\u0627\u0631 \u062f\u0627\u0631\u062f\u060c \u0646\u0647 \u06cc\u06a9 \u0622\u0631\u0627\u06cc\u0647 json.  \u06cc\u06a9 \u0639\u062f\u0645 \u062a\u0637\u0627\u0628\u0642 \u0646\u0648\u0639 \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f.<\/p>\n<p>\u0631\u0627\u0647 \u062d\u0644 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0633\u062a <code>MEMBER OF<\/code>.<\/p>\n<p>\u0627\u06cc\u0646 \u0633\u0627\u0632\u0647 \u0628\u0647 \u0646\u0648\u0639\u06cc \u0645\u0627\u0646\u0646\u062f \u06cc\u06a9 \u062a\u0627\u0628\u0639 \u0648 \u0628\u0647 \u0646\u0648\u0639\u06cc \u0645\u0627\u0646\u0646\u062f \u06cc\u06a9 \u0639\u0645\u0644\u06af\u0631 \u0631\u0641\u062a\u0627\u0631 \u0645\u06cc \u06a9\u0646\u062f.  \u0645\u0642\u062f\u0627\u0631 \u0633\u0645\u062a \u0686\u067e \u0622\u0646 \u0631\u0627 \u0645\u06cc \u06af\u06cc\u0631\u062f \u0648 \u0622\u0632\u0645\u0627\u06cc\u0634 \u0645\u06cc \u06a9\u0646\u062f \u06a9\u0647 \u0622\u06cc\u0627 \u062f\u0631 \u0622\u0631\u0627\u06cc\u0647 json \u06a9\u0647 \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0622\u0631\u06af\u0648\u0645\u0627\u0646 \u0628\u0647 \u0622\u0646 \u0627\u0631\u0633\u0627\u0644 \u0645\u06cc \u0634\u0648\u062f \u0642\u0631\u0627\u0631 \u062f\u0627\u0631\u062f \u06cc\u0627 \u062e\u06cc\u0631.<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"k\">SELECT<\/span>  <span class=\"n\">JSON_UNQUOTE<\/span><span class=\"p\">(<\/span><span class=\"n\">JSON_EXTRACT<\/span><span class=\"p\">(<\/span><span class=\"n\">some_json<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'$.artist'<\/span><span class=\"p\">))<\/span> <span class=\"k\">as<\/span> <span class=\"n\">artist<\/span><span class=\"p\">,<\/span>\n        <span class=\"n\">JSON_UNQUOTE<\/span><span class=\"p\">(<\/span><span class=\"n\">JSON_EXTRACT<\/span><span class=\"p\">(<\/span><span class=\"n\">some_json<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'$.title'<\/span><span class=\"p\">))<\/span> <span class=\"k\">as<\/span> <span class=\"n\">title<\/span>\n<span class=\"k\">FROM<\/span>    <span class=\"n\">some_data<\/span>\n<span class=\"k\">WHERE<\/span>   <span class=\"nv\">\"Queenie\"<\/span> <span class=\"n\">MEMBER<\/span> <span class=\"k\">OF<\/span><span class=\"p\">(<\/span><span class=\"k\">CAST<\/span><span class=\"p\">(<\/span><span class=\"n\">JSON_EXTRACT<\/span><span class=\"p\">(<\/span><span class=\"n\">some_json<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'$.tracks**.title'<\/span><span class=\"p\">)<\/span> <span class=\"k\">AS<\/span> <span class=\"n\">json<\/span><span class=\"p\">));<\/span>\n<span class=\"o\">+<\/span><span class=\"c1\">------------+---------------+<\/span>\n<span class=\"o\">|<\/span> <span class=\"n\">artist<\/span>     <span class=\"o\">|<\/span> <span class=\"n\">title<\/span>         <span class=\"o\">|<\/span>\n<span class=\"o\">+<\/span><span class=\"c1\">------------+---------------+<\/span>\n<span class=\"o\">|<\/span> <span class=\"n\">Bratmobile<\/span> <span class=\"o\">|<\/span> <span class=\"n\">Kiss<\/span> <span class=\"k\">and<\/span> <span class=\"n\">Ride<\/span> <span class=\"o\">|<\/span>\n<span class=\"o\">+<\/span><span class=\"c1\">------------+---------------+<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0686\u06cc\u0632\u06cc \u06a9\u0647 \u062f\u0631 \u0627\u06cc\u0646\u062c\u0627 \u0628\u0627\u06cc\u062f \u0628\u0647 \u0622\u0646 \u062a\u0648\u062c\u0647 \u06a9\u0631\u062f\u060c \u0627\u0633\u062a\u062f\u0644\u0627\u0644 \u0628\u0647 \u0627\u0633\u062a <code>MEMBER OF<\/code>.  \u0645\u0627 \u0647\u0645\u0647 \u0631\u0627 \u0627\u0633\u062a\u062e\u0631\u0627\u062c \u06a9\u0631\u062f\u0647 \u0627\u06cc\u0645 <code>title<\/code> \u0645\u0642\u0627\u062f\u06cc\u0631 \u0627\u0632 \u0633\u062a\u0648\u0646 \u0647\u0627\u06cc json \u0645\u0627 \u0648 \u0622\u0646\u0647\u0627 \u0631\u0627 \u0628\u0627 \u0647\u0645 \u062f\u0631 \u06cc\u06a9 \u0622\u0631\u0627\u06cc\u0647 \u0644\u0647 \u0645\u06cc \u06a9\u0646\u06cc\u0645.  \u0647\u0631 \u0686\u0646\u062f \u06a9\u0647 \u00ab\u0622\u0631\u0627\u06cc\u0647\u00bb \u0648\u0627\u0642\u0639\u0627\u064b \u06cc\u06a9 \u0622\u0631\u0627\u06cc\u0647 \u0646\u06cc\u0633\u062a.  \u0627\u06cc\u0646 \u06cc\u06a9 \u0631\u0634\u062a\u0647 \u0627\u0633\u062a  \u0648 \u0646\u0647 \u062d\u062a\u06cc \u06cc\u06a9 \u0631\u0634\u062a\u0647 json\u060c \u0641\u0642\u0637 \u06cc\u06a9 \u0631\u0634\u062a\u0647.<\/p>\n<p>\u0627\u0632 \u0622\u0646\u062c\u0627 \u06a9\u0647 <code>MEMBER OF<\/code> \u0628\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0633\u0628\u06a9 json \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0622\u0631\u06af\u0648\u0645\u0627\u0646 \u0646\u06cc\u0627\u0632 \u062f\u0627\u0631\u062f\u060c \u0628\u0627\u06cc\u062f \u0641\u0631\u0627\u062e\u0648\u0627\u0646\u06cc \u06a9\u0646\u06cc\u0645 <code>CAST<\/code> \u062a\u0627 \u0631\u0634\u062a\u0647 \u0622\u0631\u0627\u06cc\u0647 \u062e\u0648\u062f \u0631\u0627 \u0628\u0647 \u06cc\u06a9 \u0622\u0631\u0627\u06cc\u0647 json \u0648\u0627\u0642\u0639\u06cc \u062a\u0628\u062f\u06cc\u0644 \u06a9\u0646\u06cc\u0645.<\/p>\n<p>\u0627\u06cc\u0646 \u0631\u0627\u0647 \u062d\u0644 \u06a9\u0645\u06cc \u0622\u0634\u0641\u062a\u0647 \u0627\u0633\u062a\u060c \u0648 \u0627\u06af\u0631 \u0645\u0646 \u062f\u0631\u062e\u062a \u0627\u0634\u062a\u0628\u0627\u0647\u06cc \u0631\u0627 \u062f\u0631 \u0627\u06cc\u0646\u062c\u0627 \u067e\u0646\u0647\u0627\u0646 \u0645\u06cc \u06a9\u0646\u0645 \u0648 \u0631\u0627\u0647 \u0628\u0647\u062a\u0631 \u0648 \u0638\u0631\u06cc\u0641 \u062a\u0631\u06cc \u0628\u0631\u0627\u06cc \u0627\u0646\u062c\u0627\u0645 \u0627\u06cc\u0646 \u06a9\u0627\u0631 \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f\u060c \u0645\u0646 \u0628\u0633\u06cc\u0627\u0631 \u0622\u0645\u0627\u062f\u0647 \u0648\u0631\u0648\u062f \u0647\u0633\u062a\u0645.  \u0628\u0627 \u0627\u06cc\u0646 \u062d\u0627\u0644\u060c \u0627\u06cc\u0646 \u0633\u0627\u062e\u062a\u0627\u0631 \u06a9\u0627\u0631 \u0645\u06cc \u06a9\u0646\u062f. <\/p>\n<h2><span class=\"ez-toc-section\" id=\"%D8%B5%D8%A8%D8%B1_%DA%A9%D9%86_%D8%A7%DB%8C%D9%86_%DA%A9%D8%A7%D8%B1_%D9%85%DB%8C_%DA%A9%D9%86%D8%AF_TEXT_%D8%B3%D8%AA%D9%88%D9%86_%D9%87%D8%A7_%D9%87%D9%85%D8%9F\"><\/span>\n<p>  \u0635\u0628\u0631 \u06a9\u0646.  \u0627\u06cc\u0646 \u06a9\u0627\u0631 \u0645\u06cc \u06a9\u0646\u062f <code>TEXT<\/code> \u0633\u062a\u0648\u0646 \u0647\u0627 \u0647\u0645\u061f<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0631\u0627\u0632 \u0627\u06cc\u0646 \u0627\u0633\u062a \u06a9\u0647 \u0647\u0645\u0647 \u0686\u06cc\u0632\u0647\u0627\u06cc\u06cc \u06a9\u0647 \u062f\u0631 \u0627\u06cc\u0646\u062c\u0627 \u067e\u0648\u0634\u0634 \u062f\u0627\u062f\u0647 \u0627\u06cc\u0645 \u0631\u0648\u06cc \u0622\u0646\u0647\u0627 \u0646\u06cc\u0632 \u06a9\u0627\u0631 \u0645\u06cc \u06a9\u0646\u0646\u062f <code>TEXT<\/code> \u0633\u062a\u0648\u0646 \u0647\u0627.  \u0627\u06af\u0631 \u0622\u0646 \u0631\u0627 \u0627\u062c\u0631\u0627 \u06a9\u0646\u06cc\u0645 <code>WHERE IN<\/code> \u062f\u0631 \u0645\u0642\u0627\u0628\u0644 \u0645\u0627 \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0646\u06cc\u062f <code>some_text<\/code> \u0633\u062a\u0648\u0646\u060c \u062e\u0648\u0628 \u06a9\u0627\u0631 \u0645\u06cc \u06a9\u0646\u062f:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"k\">SELECT<\/span>  <span class=\"n\">JSON_UNQUOTE<\/span><span class=\"p\">(<\/span><span class=\"n\">JSON_EXTRACT<\/span><span class=\"p\">(<\/span><span class=\"n\">some_json<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'$.artist'<\/span><span class=\"p\">))<\/span> <span class=\"k\">as<\/span> <span class=\"n\">artist<\/span><span class=\"p\">,<\/span>\n        <span class=\"n\">JSON_UNQUOTE<\/span><span class=\"p\">(<\/span><span class=\"n\">JSON_EXTRACT<\/span><span class=\"p\">(<\/span><span class=\"n\">some_json<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'$.title'<\/span><span class=\"p\">))<\/span> <span class=\"k\">as<\/span> <span class=\"n\">title<\/span>\n<span class=\"k\">FROM<\/span>    <span class=\"n\">some_data<\/span>\n<span class=\"k\">WHERE<\/span>   <span class=\"nv\">\"Queenie\"<\/span> <span class=\"n\">MEMBER<\/span> <span class=\"k\">OF<\/span><span class=\"p\">(<\/span><span class=\"k\">CAST<\/span><span class=\"p\">(<\/span><span class=\"n\">JSON_EXTRACT<\/span><span class=\"p\">(<\/span><span class=\"n\">some_text<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'$.tracks**.title'<\/span><span class=\"p\">)<\/span> <span class=\"k\">AS<\/span> <span class=\"n\">json<\/span><span class=\"p\">));<\/span>\n<span class=\"o\">+<\/span><span class=\"c1\">------------+---------------+<\/span>\n<span class=\"o\">|<\/span> <span class=\"n\">artist<\/span>     <span class=\"o\">|<\/span> <span class=\"n\">title<\/span>         <span class=\"o\">|<\/span>\n<span class=\"o\">+<\/span><span class=\"c1\">------------+---------------+<\/span>\n<span class=\"o\">|<\/span> <span class=\"n\">Bratmobile<\/span> <span class=\"o\">|<\/span> <span class=\"n\">Kiss<\/span> <span class=\"k\">and<\/span> <span class=\"n\">Ride<\/span> <span class=\"o\">|<\/span>\n<span class=\"o\">+<\/span><span class=\"c1\">------------+---------------+<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u067e\u0633 \u0686\u0631\u0627 \u0628\u0627 <code>JSON<\/code> \u0627\u0635\u0644\u0627 \u0646\u0648\u0639 \u0633\u062a\u0648\u0646\u061f  \u062e\u0648\u0628\u060c \u0645\u0647\u0645\u062a\u0631 \u0627\u0632 \u0647\u0645\u0647\u060c \u0632\u0645\u0627\u0646\u06cc \u06a9\u0647 \u0645\u0627 \u0627\u0632 <code>JSON<\/code> \u062a\u0627\u06cc\u067e \u06a9\u0646\u06cc\u062f \u06a9\u0647 \u062f\u0631 \u062f\u0631\u062c \u06cc\u0627 \u0628\u0647 \u0631\u0648\u0632 \u0631\u0633\u0627\u0646\u06cc \u0627\u0639\u062a\u0628\u0627\u0631 \u0633\u0646\u062c\u06cc \u062e\u0648\u062f\u06a9\u0627\u0631 \u062f\u0631\u06cc\u0627\u0641\u062a \u0645\u06cc \u06a9\u0646\u06cc\u0645.  \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u0645 invliad json \u0631\u0627 \u062f\u0631 \u0622\u0646 \u0642\u0631\u0627\u0631 \u062f\u0647\u06cc\u0645 <code>TEXT<\/code> \u0633\u062a\u0648\u0646 \u0647\u0627 \u0648 mysql \u0647\u0631\u06af\u0632 \u0634\u06a9\u0627\u06cc\u062a \u0646\u0645\u06cc \u06a9\u0646\u0646\u062f.  \u0641\u0642\u0637 \u0645\u0646\u062a\u0638\u0631 \u062e\u0648\u0627\u0647\u062f \u0645\u0627\u0646\u062f \u062a\u0627 \u062f\u0631 \u0632\u0645\u0627\u0646 \u0645\u0639\u06cc\u0646\u06cc \u0646\u0627\u0627\u0645\u06cc\u062f \u0634\u0648\u06cc\u0645.<\/p>\n<p>\u062f\u0648\u0645\u060c \u0628\u0648\u0645\u06cc <code>JSON<\/code> \u0646\u0648\u0639 \u0628\u0633\u06cc\u0627\u0631 \u06a9\u0627\u0631\u0622\u0645\u062f\u062a\u0631 \u0627\u0633\u062a.  \u0622\u06cc\u0627 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u0645 \u0627\u0632 \u0645\u0642\u0627\u062f\u06cc\u0631 json \u0627\u0633\u062a\u062e\u0631\u0627\u062c\u200c\u0634\u062f\u0647 \u062f\u0631 \u067e\u06cc\u0648\u0646\u062f \u067e\u0646\u062c \u062c\u062f\u0648\u0644\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u0645\u061f  \u0622\u0631\u0647.  \u0627\u06af\u0631 \u0627\u0632 \u0622\u0646 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u0645 \u0628\u0647 \u0637\u0631\u0632 \u062f\u0631\u062f\u0646\u0627\u06a9\u06cc \u06a9\u0646\u062f \u0645\u06cc \u0634\u0648\u062f\u061f <code>TEXT<\/code>?  \u0647\u0645\u0686\u0646\u06cc\u0646 \u0628\u0644\u0647  \u0628\u0648\u0645\u06cc <code>JSON<\/code> \u0628\u0633\u06cc\u0627\u0631 \u0633\u0631\u06cc\u0639\u062a\u0631 \u062e\u0648\u0627\u0647\u062f \u0628\u0648\u062f.<\/p>\n<p>\u062f\u0631 \u0646\u0647\u0627\u06cc\u062a\u060c \u062a\u0642\u0631\u06cc\u0628\u0627\u064b \u0628\u0647 \u0637\u0648\u0631 \u0642\u0637\u0639 \u062a\u0648\u0627\u0628\u0639 \u062c\u062f\u06cc\u062f json \u062f\u0631 \u0646\u0633\u062e\u0647\u200c\u0647\u0627\u06cc \u0622\u06cc\u0646\u062f\u0647 mysql \u0648\u062c\u0648\u062f \u062e\u0648\u0627\u0647\u062f \u062f\u0627\u0634\u062a (\u0634\u0627\u0645\u0644\u060c \u0627\u0645\u06cc\u062f\u0648\u0627\u0631\u0645\u060c \u0631\u0648\u0634\u06cc \u0645\u0646\u0637\u0642\u06cc\u200c\u062a\u0631 \u0628\u0631\u0627\u06cc \u0627\u0646\u062c\u0627\u0645 <code>WHERE IN<\/code>s) \u0648 \u0647\u06cc\u0686 \u062a\u0636\u0645\u06cc\u0646\u06cc \u0648\u062c\u0648\u062f \u0646\u062f\u0627\u0631\u062f \u06a9\u0647 \u0622\u0646\u0647\u0627 \u0631\u0641\u062a\u0627\u0631 \u062e\u0648\u0628\u06cc \u0628\u0627 \u0622\u0646\u0647\u0627 \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u0646\u062f <code>TEXT<\/code>.  \u062e\u0637 \u067e\u0627\u06cc\u0627\u0646\u06cc: \u0627\u06af\u0631 \u0645\u06cc \u062f\u0627\u0646\u06cc\u062f \u06a9\u0647 json \u0631\u0627 \u062f\u0631 \u06cc\u06a9 \u0633\u062a\u0648\u0646 \u0642\u0631\u0627\u0631 \u0645\u06cc \u062f\u0647\u06cc\u062f\u060c \u0622\u0646 \u0631\u0627 a <code>JSON<\/code> \u0633\u062a\u0648\u0646<\/p>\n<blockquote>\n<p>\ud83d\udd0e \u0627\u06cc\u0646 \u067e\u0633\u062a \u062f\u0631 \u0627\u0635\u0644 \u062f\u0631 \u0648\u0628\u0644\u0627\u06af \u0641\u0646\u06cc \u06af\u0631\u0646\u062a \u0647\u0648\u0631\u0648\u0648\u062f \u0646\u0648\u0634\u062a\u0647 \u0634\u062f\u0647 \u0627\u0633\u062a<\/p>\n<\/blockquote><\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u062a\u0648\u0633\u0639\u0647 \u062f\u0647\u0646\u062f\u06af\u0627\u0646 \u0628\u06a9 \u0627\u0646\u062f \u0628\u0631\u0627\u06cc \u0630\u062e\u06cc\u0631\u0647 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc json \u0627\u063a\u0644\u0628 \u0627\u0632 firehose json \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u06a9\u0646\u0646\u062f \u0648 \u0627\u06cc\u0646 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0631\u0627 \u062f\u0631 \u0633\u062a\u0648\u0646\u200c\u0647\u0627\u06cc \u0645\u0631\u062a\u0628\u200c\u0634\u062f\u0647 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u062e\u0648\u062f \u0630\u062e\u06cc\u0631\u0647 \u0645\u06cc\u200c\u06a9\u0646\u0646\u062f. \u0627\u0645\u0627 \u062f\u0631 \u0628\u0631\u062e\u06cc \u0645\u0648\u0627\u0631\u062f\u060c \u0630\u062e\u06cc\u0631\u0647 \u06cc\u06a9 \u0634\u06cc \u06cc\u0627 \u0622\u0631\u0627\u06cc\u0647 json \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u06cc\u06a9 \u062d\u0628\u0627\u0628 \u0646\u06cc\u0632 \u0645\u0648\u0631\u062f \u0646\u06cc\u0627\u0632 \u0627\u0633\u062a. \u0627\u0645\u0627 MySQL \u0627\u0645\u06a9\u0627\u0646 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 json \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u06cc\u06a9 \u0646\u0648\u0639 \u062f\u0627\u062f\u0647 \u0628\u0648\u0645\u06cc &hellip;<\/p>\n","protected":false},"author":2,"featured_media":64225,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"","fifu_image_alt":"","footnotes":""},"categories":[339],"tags":[],"class_list":["post-64224","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dev"],"_links":{"self":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts\/64224","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/comments?post=64224"}],"version-history":[{"count":0,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts\/64224\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/media\/64225"}],"wp:attachment":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/media?parent=64224"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/categories?post=64224"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/tags?post=64224"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}