how do i edit multiple items at once?

[evilonion]

hi,

 

i am using phpmyadmin to change data in mysql database for a commerce website (creloaded)

the trouble is im trying to chnage all the dates when the products were added, but this is taking ages as each one needs to be done (810 entries)

 

is there a way that i can change the date on ALL products at once?

im new to mysql and pretty much know nothing, im just starting to get the hang of phpmyadmin for chnaging bits here and there.

[fenway]

An UPDATE statement with an appropriate where clause?

[evilonion]

forgive me for being a total numpty but how would i go about doing this?

 

when i say im new to mysql i mean the most ive done is change the odd customer email account and details etc when needed.

 

[PHP Monkeh]

You could execute this as your SQL query:

 

UPDATE `products` SET `dateAdded` = '2008-08-28';

 

Depending on what you want the date changing it to change the value after the =

 

 

[evilonion]

ah you legend thankyou for the quick replies.

thats sorted everything out.

im using creloaded but unfortunatly they dont have the best support in the world.

going to get some books on mysql etc tonight so i can start learning all this for myself.

 

thanks again, youve saved me hours of work