Return each expression=value pair for given string
<p>I'm facing a regexp issue which has been causing me headaches for hours now. I'm trying to create a regexp which will return each expression=value pair in a given SQL query. For example:</p>

<ul>
<li>given <code>(YEAR(created) = ? OR YEAR(created) = ?)</code> I want two groups, <code>YEAR(created) = ?</code> and <code>YEAR(created) = ?</code>.</li>
<li>given <code>DATE_FORMAT(col, "%d-%m") = ?</code> I want one group, <code>DATE_FORMAT(col, "%d-%m") = ?</code></li>
<li>etc.</li>
</ul>

<p>I think I'm very close: <a href="https://regex101.com/r/mX7sO8/1" rel="nofollow">https://regex101.com/r/mX7sO8/1</a> . All examples are looking good to me, except for the fact that I cannot get example one to work correctly (I want two groups, not one).</p>

<p>Can someone point me in the right direction here?</p>