First off, I know this is impossible as of MySQL 5.1.x, it says so right here: 

<http://dev.mysql.com/doc/refman/5.1/en/update.html>

What I'm asking though is if there is a clever way to execute a query using either a temporarily table/view without having to resort to writing a quick script to do the work. My query (which is COMPLETELY WRONG and DOES NOT work, just an FYI for folks trying this at home) looks something like this:

```
UPDATE some_table 
set some_col = ( SELECT some_othercol 
                 from some_table 
                 WHERE some_col > some_othercol
               );

```

I'm trying to ultimately set `some_col` to the value of `some_othercol` if `sol_col > some_othercol`. 

What's the best way to handle this without resorting to a script?

*EDIT*
My subquery returns more than one row!