Copy Data from One Field to Another along with some Text ?

ok... I've been messing with this for a while and have gotten frustrated.

Here is what I have in phpMyAdmin:

UPDATE `TABLE` SET `FIELD2` = `FIELD1'

Code (markup):

Which basically copies all the entries in FIELD1 to FIELD2. That's great, now what if I want to place some text before and after? Example:

UPDATE `TABLE` SET `FIELD2` = "Text before field data" `FIELD1' "text after field data"

Code (markup):

Does anyone know how to do this in phpmyadmin or do I have to use a php script to do this and if so, what's the code?

I thank all of you in advance, this is driving me nuts

 

use mysql concat function

UPDATE `TABLE` SET `FIELD2` = concat("Text before field data", FIELD1 , "text after field data")

 

Excellent, kuldeep, that worked great, I really appreciate it!

 

I want to do the job