how to use select result with like in mysql

Question

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

I mean something like this:

    SELECT id FROM (SELECT id,parent_id FROM units WHERE ptitle 
like '%(SELECT ptitle FROM units WHERE id='".$id."')%')

Thanks for your help.

Answer 1

you need to use concat

SELECT id FROM (

SELECT id,parent_id FROM units WHERE ptitle

like concat('%',(SELECT ptitle FROM units WHERE id='".$id."'), '%')

) sub_table