利用PHPMYADMIN执行

如果有有表前缀，需要自己拼上

update threads

set is_display = 0

where id in (select thread_id from thread_tom where tom_type in (104, 106, 107))

or price > 0 or attachment_price > 0 or is_anonymous=1;

过了以后再

update threads

set is_display = 1

where id in (select thread_id from thread_tom where tom_type in (104, 106, 107))

or price > 0 or attachment_price > 0 or is_anonymous=1;