Thanks for all the answers, you all seemed very surprised by the seemingly easy answer
SELECT old_name as new_name FROM ... which made me feel rather at ease. I realized the problem wasn't with mySQL - for it certainly did work as it should. even my way - without the as. Problem was with darn darn Excel, which I have to get to work with mySQL. So - problem solved. Thanks guys and girls! ________________________________________________________ Mikaela Holmberg R&D Systems Developer OSIX AB, Lumaparksvägen 9, SE-120 31 Stockholm, Sweden Tel +46 (0)8 50 600 667, Fax +46 (0)8 50 600 601 Mob +46 (0)70 537 06 67, [EMAIL PROTECTED] http://www.osix.se The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php