title: Proper regular expression in PostgreSQL
body: <p>I have a table called regions and column region which is not empty. There is a text in it, which is 'Tashkent'. I am trying to access it with expression input. Here is my code:</p>
  
  <pre><code>select * from regions where lower(region) ~ '[t]{1,}[k]{1,}';
  </code></pre>
  
  <p>As you can see, I am trying to get the word which contains letters <code>t</code> and <code>k</code> consecutively. According to my expression: <code>[t]{1,}[k]{1,}</code> above it should return text <code>'Tashkent'</code>, but not returning. Is my code correct. Can you suggest an alternative code to get word 'Tashkent' knowing that I have letters <code>t</code> and <code>k</code>? </p>