5haun Posted February 10, 2015 Share Posted February 10, 2015 (edited) Hi All I don't know SQL well at all and I was hoping someone can provide a query that I can use to change the date for certain products were added (multiple product ID's). As far as I know the date_add field needs to be change in both ps_product and ps_product_shop. Any help would be greatly appreciated! Edited February 11, 2015 by 5haun (see edit history) Link to comment Share on other sites More sharing options...
vekia Posted February 10, 2015 Share Posted February 10, 2015 update ps_product_shop set date_add='date here' where id_product in (1,2,3,4,5) where 1,2,3,4,5 are an ID numbers of products. 2 Link to comment Share on other sites More sharing options...
5haun Posted February 11, 2015 Author Share Posted February 11, 2015 where 1,2,3,4,5 are an ID numbers of products. Awesome thank you!!! Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now