title: MySQL - Escaping double quotes and brackets when querying JSON column
body: <p>how do you escape double quotes and brackets when querying a JSON column containing an array of objects?</p>
  
  <p>This works when I run it... </p>
  
  <pre><code>SELECT boarded, boarded-&gt;&gt;"$[0].division.id" AS divisionId FROM onboarder
  </code></pre>
  
  <p>But this doesn't...</p>
  
  <pre><code>SELECT boarded, boarded-&gt;&gt;"$[*].division.id" AS divisionId FROM onboarder
  </code></pre>
  
  <p>I thought double arrows escaped everything and bought back only the value. This is what I have...</p>
  
  <p><a href="https://i.stack.imgur.com/7YlQf.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/7YlQf.png" alt="enter image description here"></a></p>