title: PostgreSQL query on a text column ignoring special characters
body: <p>I have a table which contains a text column, say vehicle number.</p>
  
  <p>Now I want to query the table for fields which contain a particular vehicle number.</p>
  
  <p>While matching I do not want to consider non-alphanumeric characters.</p>
  
  <pre><code>example: query condition - DEL123
           should match    - DEL-123, DEL/123, DEL@123, etc...
  </code></pre>