title: Syntax for input parameters in a MySQL query
body: <p>We recently switched a database from MSSQL to MySQL and the queries that uses parameters does'nt work anymore.</p>
  
  <p>Here's an example of a query in MSSQL:</p>
  
  <pre><code>SELECT * FROM users u WHERE u.ID = :id
  </code></pre>
  
  <p>Normally, the parameter browser would popup and ask me for a value for :id, but in MySQL I get this error : </p>
  
  <p>You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':id'</p>
  
  <p>I tried using a @ or ? instead of : and it does'nt work.</p>
  
  <p>Thanks in advance for the help.</p>