update table1 set field1=CONCAT('N',field1);

should work, haven't tested it though.


"George Pitcher" <[EMAIL PROTECTED]> wrote in message
00e101c12a13$2db49880$[EMAIL PROTECTED]">news:00e101c12a13$2db49880$[EMAIL PROTECTED]...
> Hi all,
> I have a MySQL table with approx 350,000 records (US aviation register)
> the way the FAA produce it is without the 'N' prefix which I wish to add.
> Can anyone point me to a sql command which will upodate the N-Number field
> to 'N' + N-Number field?
> George, Edinburgh
> _________________________________________________________
> Do You Yahoo!?
> Get your free @yahoo.com address at http://mail.yahoo.com

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to