Use LIKE %..% with field values in MySQL

Use:

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

mysql sql sql-like

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

because the last answer not work

CodeHunter