Mass update product expected dates via SQL query

[misaki]

Hello~

I've been wondering how I can mass update the product expected date through SQL query for items that have already been assigned a specific date. For example, items that come available 5/21/2010, I would like to change them all to be available 6/10/2010.

I've tried using EasyPopulate to do this, but it didn't work for me, so I would prefer to do it this way through SQL. Just not sure how to go about it.

Thanks!

[dbltoe]

You will need to develop a mysql update query that modifies the products_date_available field in the products table. Pay attention to the date format in the table.

[misaki]

Thanks for your fast response!

Let me see if I can give it a shot.

UPDATE products SET products_date_available= 20100610 WHERE products_date_available = 20100521;

A really big guess on the date formatting, but it might be right! =)

[dbltoe]

http://dev.mysql.com/doc/refman/5.0/en/update.html will help with the syntax.
The format for the date should be 0001-01-01 00:00:00


BACKUP!!!!!!!!!!!!!!