getting a col value from an UPDATE query

[steamPunk]

Hi

I was wondering how i could return a specific column value from a row affected by an UPDATE

so imagine i have 4 cols in my table col1,col2,col3,col4

i would want to update col2 and col 3 where col1='n' and return the value of col4 so that i can use it in my php code

i know how to use a SELECT subquery in an INSERT to insert a bit of data from another table -

but i can't figure out if and how i could do the same sort of thing here

I've looked at the MySQL manual but can't find an example, so maybe this kind of composite query can't be done ...

[steamPunk]

in the end i used two queries for each one - but i'd be interested to know if it's possible because when i do a couple of thousand updates it would halve the number