Update column when datetime = NOW()

[Trevor Pan]

Hi,

developing a laravel app which uses mysql 8.

I have a column which is set upon creation to 0. I'd like to automatically update it to 1 when datetime = NOW().

Originally, had made a javascript component which called a method but later found out that calls the method/emails each time someone viewed the page.

I later thought perhaps a cron job would be suitable for this. So, run a job every minute in search of records where datetime >= NOW(). But that seems like it would update recently passed times but also ALL the other records that are >= NOW().

Any ideas?

Thank you,

Trevor