mysql - Update two columns in sql -

this table of data need change.

select appid, categoryid, categoryname, classdesc apps join appscategories using(appid) join categories using (categoryid) join classes using (classid) classdesc = "auto" 

which returns this:

appid         categoryid         categoryname        classdesc  400           100                public              auto 405           101                business            auto 410           102                auto                auto 415           102                auto                auto 

i want update table data below updated have categoryname of auto categoryid of 102. need use select statement above somehow unsure how update both columns. appreciated!

assuming wanting update these 2 columns every row in table, should work.

update apps join appscategories b     on a.appid = b.appid             //whatever keys join categories c     on b.categoryid = c.categoryid   //whatever keys join classes d     on c.classid = d.classid         //whatever keys set categoryid='102', categoryname='auto' classdesc = "auto"