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. 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 been able to get the update to work on numeric values based on the > MySQL docs but cannot figure out how to perform the update on strings. > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
