How to implement automatic launch of a stored procedure once every two days in MySQL?

Question

MySQL

Is it possible in MySQL to implement such a stored procedure that will run every two days, assign a specific value to a certain column in all records, and then select three random records and assign another value to the same column? In this way, I would like to rotate random records on the site that change every two days, but I'm not well versed in stored procedures.

Answer 1

Don't worry, use cron (for Windows - nncron)