Like with the results of a subquery (multiple values)
Rewrite it into a JOIN

SELECT t1.field1, t1.field2, t1.field3 
FROM
    table1 t1
    JOIN
    (SELECT distinct field AS fieldx from table2) t2 
    ON t1.field3 like CONCAT('%',fieldx,'%')