update IN 失效不起作用

有时以下语句不起作用
UPDATE `table1` SET status=10 WHERE id IN(SELECT id FROM ``table2` where `url` LIKE '%www.taoaoke.com%')
update table1 as a inner join (select id from table2 where `url` LIKE '%www.taoaoke.com%') as b set status=10 where a.id=b.id
update table1  a inner join (select id from table2  where `url` LIKE '%www.taoaoke.com%')   b on a.id=b.id set status=10