MySQL bound variable for LIMIT to default to none
<p>Unless I have specified a limit </p>

<pre><code>    $values = [
        ':limit' =&gt; $this-&gt;limit,
        ':offset' =&gt; $this-&gt;offset
    ];
</code></pre>

<p>by setting <code>$this-&gt;limit</code>, I want this bound to default to no limit</p>

<pre><code>const QUERY = "SELECT * FROM Project LIMIT :limit OFFSET :offset";
</code></pre>

<p>I've tried something like</p>

<pre><code>    $values = [
        ':limit' =&gt; $this-&gt;limit ? $this-&gt;limit : null,
        ':offset' =&gt; $this-&gt;offset
    ];
</code></pre>

<p>But I wondered if there was a key word in SQL to ignore the limit flag. I.e. <code>LIMIT ALL</code> - if that makes sense.</p>