Find 30 days ago and INSERT....

[timmylogue]

I'm trying to search for passed dates (30 days ago) in my database and then INSERT 'expired' value into a column called 'trial_date_ended'.

 

The dates/passed dates are in a column field called "trial_date_started"

 

Here an example of what I thought would work but doesn't work: 

$sql="INSERT INTO users (trial_date_ended) VALUES  ('expired') < (NOW() - INTERVAL 30 DAY)";

 

 

Thanks for your help!

 

Tim

[Barand]

Sounds like you need an UPDATE query

UPDATE users
SET trial_date_ended = 'expired'
WHERE trial_date_started < CURDATE() - INTERVAL 30 DAY

[timmylogue]

Thank you! Worked!