title: MySQL Error Code: 1305. FUNCTION JSON_EXTRACT does not exist in MySQL client version: 5.5.52
body: <blockquote>
  <p><strong>Goal :- json_extract does not exist error.</strong></p>
  </blockquote>
  <p>I do have message body like this.</p>
  <pre><code>  &lt; message type = &quot;chat&quot;
    to = &quot;socialapp_233@22.52.258.256&quot;
    from = &quot;socialapp_6@22.52.258.256/9fs4kgn090&quot; &gt; &lt; body &gt; {
      &quot;opponent_xmpp_id&quot;: &quot;socialapp_233@22.52.258.256&quot;,
      &quot;latest_message_id&quot;: &quot;6233&quot;
    } &lt; /body&gt;&lt;active&gt;http:/ / jabber.org / protocol / chatstates &lt; /active&gt;&lt;/message &gt;
  </code></pre>
  <p>I am trying to extract <strong>opponent_xmpp_id</strong> and <strong>latest_message_id</strong>.</p>
  <p>for that i have written a query like below.</p>
  <pre><code>SELECT  LEFT(ExtractValue( stanza, &quot;//@from&quot; ),LOCATE(&quot;@&quot;,ExtractValue( stanza, &quot;//@from&quot; )) - 1),
          LEFT(ExtractValue( stanza, &quot;//@to&quot; ),LOCATE(&quot;@&quot;,ExtractValue( stanza, &quot;//@to&quot; )) - 1),
          ExtractValue(stanza, &quot;//body&quot;),
          ExtractValue(stanza, &quot;//@chattype&quot;),
          TRIM(BOTH '&quot;' FROM json_extract(ExtractValue(stanza, &quot;//body&quot;), '$.opponent_xmpp_id')) AS opponent_xmpp_id,
          json_extract(ExtractValue(stanza,&quot;//body&quot;),'$.latest_message_id') AS latest_message_id        
  FROM
  ofOffline
  </code></pre>
  <p>causes error</p>
  <blockquote>
  <h1>1305 - FUNCTION databaseName.json_extract does not exist</h1>
  </blockquote>
  <p>As per i searched its supporting in &gt; MYsql 5.7 version only.</p>
  <p>So is there any function which do the simmilar job as json_extract in MySQL client version: 5.5.52 ?</p>