Regular expression to extract a JSON array
<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>