查询更新MYSQL数据库中的数据，在表1中搜索，在表2中更新，如何？

I am trying to figure out how to quickly change some stuff in a large wordpress database, doing through the GUI takes forever, i think executing this direclty on the database would be much more efficient as it's a one time thing.I am trying to figure out how to quickly change