title: Postgres SELECT statement where field value ends with
body: <p>I have a postgres database table called: web_data</p>
  
  <p>Currently i'm running the following SQL select statement:</p>
  
  <pre><code>SELECT url_path FROM web_data WHERE url_path IS NOT NULL
  </code></pre>
  
  <p>Here are some example results I will get for url_path:</p>
  
  <pre><code>/
  /aboutus.html
  /services.php
  /images/twitter_counter.png
  /images/facebook_counter.png
  /mobile/windows/TileTemplate.xml
  /en_US/fbevents.js
  /css/style.css
  </code></pre>
  
  <p>I would like to return results where the end value of url_path is either one of the following:</p>
  
  <pre><code>/
  .html
  .htm
  .php
  .asp
  .aspx
  .pdf
  </code></pre>
  
  <p>Is there a way to put this into the SQL statement instead of getting all results and then going through it with something like PHP?</p>