PhotoPost Community - View Single Post - SQL to mass change duration of existing ads

creativepart · February 21st, 2007, 10:21 AM

I've had a devil of a problem with old ads. Seems I didn't notice the "no expire" option was available and a lot of my users selected that option.

I've now gone in and changed the duration options in my templates, but I have about 45 ads in the database with a duration of 9999. I'd like to change all of those to 30 days and let them expire out of the system.

Could you please give me an example of an SQL command that I can run to mass change all ads in the product table with a duration of 9999 to a duration of 30?

I sure would appreciate it.

Thanks
Paul Green

February 21st, 2007, 10:21 AM	#1 (permalink)
creativepart Member Verified Customer Join Date: May 2003 Location: Spring Branch, Texas Posts: 247	SQL to mass change duration of existing ads I've had a devil of a problem with old ads. Seems I didn't notice the "no expire" option was available and a lot of my users selected that option. I've now gone in and changed the duration options in my templates, but I have about 45 ads in the database with a duration of 9999. I'd like to change all of those to 30 days and let them expire out of the system. Could you please give me an example of an SQL command that I can run to mass change all ads in the product table with a duration of 9999 to a duration of 30? I sure would appreciate it. Thanks Paul Green