pafranklin Posted December 11, 2018 Share Posted December 11, 2018 Hi all, I've uploaded some products to my site and then started to make amendments. I've then spotted the date available is incorrect. Therefore I am trying to select products added today 11th December and updating all of them to be available on 10th February 2019. I have this so far but pretty sure this is not correct?! UPDATE `products_date_available`= `2019-02-10 00:00:00` FROM `products` WHERE `products_date_added` = `2018-12-12 00:00:00` Please would someone be kind enough to correct this or tell me where I am going wrong? Many thanks. Paul You will never learn if you don't try. And boy am I trying....! Link to comment Share on other sites More sharing options...
pafranklin Posted December 11, 2018 Author Share Posted December 11, 2018 Duh, got there in the end so just in case anyone else ever looks for something like this its as follows: UPDATE `products` SET `products_date_available` = '2019-02-10' WHERE `products_date_added` = '2018-12-11' Paul You will never learn if you don't try. And boy am I trying....! Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.