Use LIKE% ..% with field values ​​in MySQL

Question

I came across a subtle SQL problem when I needed to use a value from a field inside a LIKE% ..% statement.

Example:

SELECT t1.Notes, t2.Name FROM Table1 t1, Table2 t2 WHERE t1.Notes LIKE '%t2.Name%' 

This is just an example from the top of my head to show what I need to do (I know this will not work). I need to use the t2.Name value inside LIKE% ..%

I think this is trivial when you know it;)

Answer 1

Using:

 SELECT t1.Notes, t2.Name FROM Table1 t1 JOIN Table2 t2 ON t1.Notes LIKE CONCAT('%', t2.Name ,'%') 

Answer 2

  SELECT t1.a, t2.b FROM t1 JOIN t2 ON t1.a LIKE '%'+t2.b +'%' 

because the last answer does not work