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, b3119f6547dca910c342593656x480.jpg...how 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) dskims.com, All Rights Reserved.

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