list rows with no recent updates

[MadTh]

Hi,


I ran a update command on around 2700 rows inside a mysql database table
which has around 3000 table rows to change the ( say)  price of each item (
with unique ID. unique product code).

like:

mysql> UPDATE tbl_xyz  set listprice='9.45' where prod_id='3069' and
prod_code='a0071';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0




How can I list rows with no recent updates ( or the once where the above
updates were not done)  or say with no updates in last 2 hours?





Thank you.