title: How to extract parameters names from SQL statement using regular expression
body: <p>I want to extract the parameters names from a query like this:</p>
  
  <pre><code>select * from table where a = :param1 and b = :param2
  </code></pre>
  
  <p>I wrote this expression:<code>"(?&lt;param&gt;:\w* )"</code></p>
  
  <p>It gives me <code>:param1</code> twice</p>
  
  <p>Note: It's in a C#.Net application.</p>
  
  <p>Any Help !!</p>
  
  <p>Thanks</p>