kris burford wrote: >>> is there a means i can do something like >>> update table set (foo='1' where id ='1'), (foo='2' where id='2'); > can't believe that there's not a simpler method... Well I don't know about MySQL, but SQL2k supports this: UPDATE Table SET foo=id Is that what you want?