shadyns Posted February 4, 2014 Share Posted February 4, 2014 (edited) Hello, again i need some help from you guys. We have a lot of products and all are typed deferent. Some with upercase some lower some both so is there a way to mass change all product names for example to all lowercase and capitalize ? Pls hel me how to do it faster so i dont need to edit one to one .... Edited February 5, 2014 by shadyns (see edit history) Link to comment Share on other sites More sharing options...
vekia Posted February 4, 2014 Share Posted February 4, 2014 you can use sql query capitalize: UPDATE ps_product_lang set name= CONCAT(UPPER(LEFT(name, 1)), SUBSTRING(name, 2)); uppercase: UPDATE ps_product_lang set name=upper(name); lowercase: UPDATE ps_product_lang set name=lower(name); 1 Link to comment Share on other sites More sharing options...
shadyns Posted February 5, 2014 Author Share Posted February 5, 2014 This forum iz perfect every time i was need something i get help same thay... thank you.. Solved Link to comment Share on other sites More sharing options...
vekia Posted February 6, 2014 Share Posted February 6, 2014 you're welcome glad to hear that i could help you a little i marked this thread as [solved] with regards, Milos Link to comment Share on other sites More sharing options...
.png.022b5452a8f28f552bc9430097a16da2.png)
Recommended Posts