Reverse SQL LIKE

Question

Is it possible in SQL (more precisely, PostreSQL) to match a row with a template stored in a table, so that when I have a DB field containing %some% , I could select its row something like this:

 SELECT * FROM table_name WHERE field_value LIKE 'Awesome stuff' 

Thanks.

Answer 1

 SELECT * FROM table_name WHERE 'Awesome stuff' LIKE field_value