Help with UPDATE command...

Here is the code I am trying to implement... update table set col1=value where condition=true and condition=true order by col2 desc, col3 desc limit 1; The UPDATE command does not seem to support the ORDER BY part despite it being listed in the instructions on the mysql.com website. Is there any workaround to this that anybody knows of? Thanks in advance for your help. :o) -- Tony Tzankoff http://www.tzankoff.com =========================