How do I add characters to end of multiple field data?
Posted: Tue Apr 23, 2013 8:56 am
We have 400+ filenames in a database, ie. 45454343. I need to change them all to 45454343.jpg for instance. So they all have ".jpg" put on the end.
How can this be done, via phpMyAdmin? I'm assuming it some kind of "replace" function, but not sure.
Simon
How can this be done, via phpMyAdmin? I'm assuming it some kind of "replace" function, but not sure.
Simon