select in a LIKE?

Hi

Can I construct a LIKE out of a select query? Something like

select * from users where name like '%(select name from blah)'

Currently, this won't work.

--Arsalan
-------------------------------------------------
WAR IS PEACE
FREEDOM IS SLAVERY
IGNORANCE IS STRENGTH
--1984