how to create mysql query for this criteria?

Question

Hi,

I have to write an query something like this

select * from table where title like '% select from tableb %'

this select from tableb is a query and not a string

Answer 1

You've basically got it:

You can do this: SELECT * FROM table where title like (SELECT column FROM tableb WHERE id=case)

Answer 2

i found it

select * from table where title like '%'+ select from tableb +'%'