如何在MySQL中使用select结果?

I need some MySQL code that uses a select output in LIKE statement in WHERE.I need some MySQL code that uses a select outpu