sql - Query to get specific patterns from column -


one of table column contains below value.

all files (*.*)|*.*|bitmap (*.bmp)|*.bmp|microsoft word document (*.docx)|*.docx|gif (*.gif)|*.gif|jpeg (*.jpg)|*.jpg|png (*.png)|*.png|adobe reader (*.pdf)|*.pdf|tiff (*.tif)|*.tif 

i need query fetch bmp,docx,gif,jpg,png,pdf,tif above values. these values present in brackets.

is want ?

select *  your_table  column_with_types in ('(.bmp)','(.docx)','(.gif)','(.jpg)','(.png)','(.pdf)','(.tif)') 

Comments