Look for concat :
http://dev.mysql.com/doc/mysql/en/string-functions.html
On Wed, 16 Mar 2005 15:51:34 -0500, David DeSana
<[EMAIL PROTECTED]> wrote:
> I need to modify the value of file names in a table. The strings represent
> an image file path and are stored in a char column in the table. He
I need to modify the value of file names in a table. The strings represent
an image file path and are stored in a char column in the table. Here is a
sample of the values:
\products\1_TH.JPG
\products\2_TH.JPG
I would like to perform the following
UPDATE test.Items SET Desc='New'+Desc
I've bee
