Mysql replace part of text within Join -

is possible replace part of text in join? unsuccessful attempt @ below. thanks

        select table1.name3         table2         left join table1         on table2.name3 = replace(table1.name4, 'this', 'that')          , table2.name2 = table1.name2         table2.f_name = 'steve'