Try using CONCAT() ;
mysql> update inventory_items set
image_location=concat(item_number,'-1.jpg');
Thanks
ViSolve DB Team.
----- Original Message -----
From: "Jerry Jones" <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
Sent: Saturday, February 03, 2007 12:00 PM
Subject: Update queries
I need to run a query that will take the data from item_number field,
add "-1.jpg" to the end of it, and store it in image_location
I have tried update inventory_items set image_location = item_number +
"-1.jpg";
but that just places the item number into the field, without the text
in quotes.
How do I append some fixed text to another field entry and place it
into a different field?
--
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]
