title: Dynamic parameters in where clause
body: <p>I have a problem with a select count in my stored procedure, it looks like that when I use two dynamics parameters it refuse to works.</p>
  
  <p>For example :</p>
  
  <p>1.</p>
  
  <pre><code>SELECT COUNT(*)
  INTO @var
  FROM TMP_TABLE
  WHERE UDA10 = 3;
  </code></pre>
  
  <p>Works perfectly</p>
  
  <p>2.</p>
  
  <pre><code>SELECT COUNT(*)
  INTO @var
  FROM TMP_TABLE
  WHERE UDA10 = @vlQuota
  </code></pre>
  
  <p>Works too</p>
  
  <p>3.</p>
  
  <pre><code>    SELECT COUNT(*)
      INTO @var
      FROM TMP_TABLE
      WHERE @llQuota = 3;   
  </code></pre>
  
  <p>Doesn't work (always return 0)</p>
  
  <ol start="4">
  <li><p>(The one I want)</p>
  
  <pre><code>SELECT COUNT(*)
  INTO @var
  FROM TMP_TABLE
  WHERE @llQuota = @vlQuota;
  </code></pre></li>
  </ol>
  
  <p>Doesn't work (always return 0)</p>
  
  <p>So the problem may be with the @llQuota parameter but when I check it returns "UDA10" like it should.</p>
  
  <p>I also tried to execute the query with PREPARE and EXECUTE but I have the same problem.</p>
  
  <p>EDIT : UDA10 is a column I put in example, it can be anything that why I use @llQuota and not directly UDA10. The problem may be that MySQL does not understand @llQuota is a column.</p>