How to run a "replace" in phpmyadmin

Hello,

I have a mailer and yesterday site crashed I had to re install everything.
I imported my lists but now they are all dated from 2021-01-01 (see "Created_at" ) https://prnt.sc/wemqw7
This causes problem because i need to setup my triggers (auto responder) and as they are marked 2021-01-01 they will receive the 2nd message of the drip campaign. They already received it weeks ago,
Can someone please let me know how to change the Created_at date to 11-30-2020
Thank you

You have to modify the values on the sql table.

It's generating the date on creation of the row or you can say on insert.

Click on change and check the settings for created_at column. I think you will see something like current timestamp etc you can change it to dateandtime format so it will pick the date from your backup file maybe.

Not exactly an expert in sql but in past did some things so i remember a bit, Maybe you can try the above suggestion.

Thanks

this will do the job , but try if you know what you are doing and you are well versed with mysql commands

https://www.w3schools.com/sql/sql_update.asp

thank you
So if my table is "mc_contacts"

Command should be

UPDATE mc_contacts
SET Created_at='2020-11-30 16:02:02 ';
?
Correct?
Thanks

avidjam said:

https://www.w3schools.com/sql/sql_update.asp

Click to expand...

yes if you want to update on all rows in that table

yes i want to update ALL the records (email addresses) so they are all dated from 2020-11-30

Youtube-Toys said:

yes if you want to update on all rows in that table

Click to expand...