how to add some content after a field value by phpmyadmin?

there is a table named product which has a field named image. the value of it like the following: b3119f6547dca910c342593656 b3119f6547dca910c342534y.....

now i want to add x480.jpg after every value. namely, do i do it by phpmyadmin? thank you

-------------Problems Reply------------

You can run a simple SQL like this:

UPDATE product
SET image = CONCAT(image, 'x480.jpg')

Category:mysql Views:0 Time:2011-11-01
Tags: mysql

Related post

Copyright (C), All Rights Reserved.

processed in 0.066 (s). 11 q(s)