When using postgres, we sometimes need to find fields that match multiple like queries. 

In this situation we can use like any. Making use of the any expression.


select * from some_table where some_field like any  (
    select '%'||some_other_field||'%' from some_other_table


Matt Reid

Lead Software Architect. Java, Node.js and TypeScript enthusiast.

drei01 Matthew_Reid