Using LIKE with a subquery in SQL

Use LIKE (and ILIKE) on an array or statement by doing ilike any( ... )

select * where x ilike any(
	select
		'%' || '%' || y
	from table 
)

This works in Postgrs, at least.