求教，请大神帮忙 合并下MySQL语句

Question

update women_cb m,wptag w set m.status=2 where w.status=1 and find_in_set(w.id_product,m.ids)

select w.id_product,m.ids from women_cb m,wptag w where w.status=1 and find_in_set(w.id_product,m.ids)

Answer 1

不懂你想做什么，你想更新还是查询？还是想用unionall