title: Combining JSON_SEARCH and JSON_EXTRACT get me: "Invalid JSON path expression."
body: <p>I have a table names &quot;campaigns&quot;. One of the columns is named &quot;filter_apps&quot; and his type is <strong>JSON</strong></p>
  <p>I have file rows and they just contain array of tokens like so:</p>
  <pre><code>[&quot;be3beb1fe916ee653ab825fd8fe022&quot;, &quot;c130b917983c719495042e31306ffb&quot;]
  [&quot;4fef3f1999c78cf987960492da4d2a&quot;]
  [&quot;106c274e319bdeae8bcf8daf515b1f&quot;]
  [&quot;2521f0df6cffb7487d527319674cf3&quot;]
  [&quot;c130b917983c719495042e31306ffb&quot;]
  </code></pre>
  <p>Examples:</p>
  <pre><code>SELECT JSON_SEARCH(filter_apps, 'one', 'c130b917983c719495042e31306ffb') FROM campaigns;
  </code></pre>
  <p>Result:</p>
  <pre><code>&quot;$[1]&quot;
  null
  null
  null
  &quot;$[0]&quot;
  </code></pre>
  <p>Right now everything is correct, the matched columns come back. If I make a test I can prove it:</p>
  <pre><code>SELECT JSON_EXTRACT(filter_apps, '$[1]') FROM campaigns;
  </code></pre>
  <p>Result</p>
  <pre><code>&quot;c130b917983c719495042e31306ffb&quot;
  null
  null
  null
  null
  </code></pre>
  <p>So at this point I think I can extract the values using JSON_EXTRACT, my query:</p>
  <pre><code>SELECT JSON_EXTRACT(filter_apps, JSON_SEARCH(filter_apps, 'one', 'c130b917983c719495042e31306ffb')) FROM campaigns;
  </code></pre>
  <p>That leads me to an error:</p>
  <p>&quot;[42000][3143] Invalid JSON path expression. The error is around character position 1.&quot;</p>