-- mysql join query using like SELECT * FROM Table1 INNER JOIN Table2 ON Table1.col LIKE CONCAT('%', Table2.col, '%') -- http://stackoverflow.com/questions/1930809/mysql-join-query-using-like