对于这种情况使用 NOT EXISTS:

select *
from table1 t1
where not exists
(
  select *
  from table2 t2
  where t2.`table2-name` like concat('%', t1.`table1-name`, '%')
);

顺便说一句:您应该避免使用诸如 table2-name 之类的名称，在这些名称中您需要引号才能使用它们.改用 table2_name 之类的东西.

BTW: You should avoid names like table2-name where you need quotes in order to use them. Use something like table2_name instead.