Regular expression for extracting an IP address from a string in PSQL
===

I am dealing with a table called ipaddr with a column called destination and have entries in the column that look like and are of type varchar

tunnel://169.96.88.11:80/

>How do you write a regular expression so that I select rows in the table based on a specific ip address subnet?

select * from ipaddr where destination like '%169.96.88%'

(That is i am tying to collect all records who have a destination entry in the 169.96.88.* block)