Join Where Contains ?????

hello everyone,

Please can someone tell me if it is possible to create a Join on two tables where the value from 1 field is contained within a field from the other table.

eg.

table1.field = "xyz"

table2.field = "the xyz super thingy"

This is the SQL it gave me orrigionally but this is an "= to" join which is not what i want. I tried replacing the = with a LIKE but am still getting the same results.

SELECT table1.*, table2.*
FROM table1 INNER JOIN table2 ON table1.modelno = table2.name;

SELECT table1.*, table2.*
FROM table1 INNER JOIN table2 ON table1.modelno LIKE table2.name;