UPATE Using Max?

2002-03-07 Thread Victoria Reznichenko
Rutledge, Wednesday, March 06, 2002, 10:01:56 PM, you wrote: Reoen In my application I would like to update a MySQL record where one Reoen column Reoen is the largest value. Do I have to create a separate SELECT sql query Reoen statement Reoen to get that value and then update it? Or, is

UPATE Using Max?

2002-03-06 Thread Rutledge, Aaron
Hello, In my application I would like to update a MySQL record where one column is the largest value. Do I have to create a separate SELECT sql query statement to get that value and then update it? Or, is there a function that allows me to specify it as part of my WHERE clause. I scanned