Page 1 of 1

How do I add characters to end of multiple field data?

Posted: Tue Apr 23, 2013 8:56 am
by simonmlewis
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

Re: How do I add characters to end of multiple field data?

Posted: Tue Apr 23, 2013 12:49 pm
by requinix
Do an UPDATE and use the CONCAT function.