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]
