Help with mysql query

[richie]

My db has possible duplicate records, but I want to update the most recent record among the duplicates.

A pseudo code would be:

db_query("UPDATE inventory SET active = '1' where storeid = '1354' && 'postDate is max' ");

postDate is in the database in this DATETIME format:

2000-09-18 00:00:00

Kindly help translate

postDate is max

in the pseudocode into proper mysql syntax.

Thanks.
Richie.

[LordShryku]

Assuming you're using a database with subquery functionality, this would work

UPDATE inventory 
   SET active = '1' 
 WHERE storeid = '1354' 
   AND postDate = (SELECT max(postDate)
                     FROM inventory
                    WHERE storeid = '1354')