agallo Posted September 17, 2008 Share Posted September 17, 2008 First, thanks in advance for any help provided in finding this solution. I have been searching for the right string for a day now with no luck. I am trying to add a zero to the end of prexisting values, in all rows, and in a specific column. Any help as to the right query or pointing me in the right direction is much appreciated. Quote Link to comment Share on other sites More sharing options...
Mchl Posted September 17, 2008 Share Posted September 17, 2008 Are they numeric or strings? For numeric UPDATE table SET field = field * 10; For strings UPDATE table SET field = CONCAT(field,'0'); Quote Link to comment Share on other sites More sharing options...
agallo Posted September 17, 2008 Author Share Posted September 17, 2008 perfect! thank you so much for the help Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.