title: Match column values and ignoring special characters in PostgreSQL 11.0
body: <p>I have following table in PostgreSQL 11.0</p>
  <pre><code>name                                            identifier  name_matched
  anti-angin® formula                             3792673     anti angin
  anti-angin® formula                             3792673     anti angin
  arava® 20 mg tablets                            D25155      arava 20 mg
  nifedipine extended release tablets 60 mg       23766       nifedipine
  </code></pre>
  <p>I using following query to match name and name_matched values.</p>
  <pre><code>select * from tbl
  where name ilike '%' || name_matched || '%' 
  </code></pre>
  <p>Above query only give row4 as an output. How can I modify the query to fetch all four rows (ignoring special characters and then match the strings)</p>
  <p>Any help is highly appreciated</p>