Restrict users from changing rows inserted 3 hours ago in mysql

Question

I inserted a few lines 3 hours ago and I do not want these lines to change. How can I write a sql statement that will compare the current time with a timestamp in a string and prevent users from changing it if the above criteria are met.

thank

Answer 1

If you want to do this with mysql, you will need to use a statement INTERVALthat will allow you to “add” functions from time to time ... for example:

UPDATE table
SET data = 'whatever'
WHERE NOW() - INTERVAL 3 HOUR  < last_change

Here you can find additional information and examples: Date and time functions

Answer 2

WHERE :

UPDATE yourtable
SET foo = bar
WHERE inserttime > NOW() - interval 3 hour