在一个或很少的查询中更新多个MySQL行的显示顺序

I have a table with say 20 rows each with a number for display order (1-20).I have a table with say 20 rows each with a num