[MySql] Like con valori da tabella

[optime]

prova con

SELECT T1.* FROM users T1 JOIN b_no2 T2 ON T1.email_address LIKE CONCAT ('%', T2.bno_email, '%')