title: Regular expression to extract a JSON array
body: <p>I'm trying to use a PCRE regular expression to extract some JSON. I'm using a version of MariaDB which does not have JSON functions but does have REGEX functions.</p>
  
  <p>My string is:</p>
  
  <p><code>{"device_types":["smartphone"],"isps":["a","B"],"network_types":[],"countries":[],"category":["Jebb","Bush"],"carriers":[],"exclude_carriers":[]}</code></p>
  
  <p>I want to grab the contents of <code>category</code>. I'd like a matching group that contains 2 items, <code>Jebb</code> and <code>Bush</code> (or however many items are in the array).</p>
  
  <p>I've tried this pattern but it only matches the first occurrence: <code>/(?&lt;=category":\[).([^"]*).*?(?=\])/g</code></p>