lets says the column your_column holds hte data to be changed. then: update your_table set your column=concat(substring(your_column,1,4),-,substring(your_column,5,8),-,subs tring(your_column,8,12)); this should work, if i am wrong please someone correct me cheers ) ----- Original Message ----- From: "Gill, Vern" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, December 03, 2001 7:22 PM Subject: Changing data
> how would I change in all rows data that is; > 0000000000 > > to > > 000-000-0000 > > or (000) 000-0000 > > Can this even be done with mysql? > > Thank you in advance... > > Vern H. Gill > State Director > Director of Marketing > Conejo Valley Jaycees > http://www.conejovalleyjaycees.org > > --------------------------------------------------------------------- > 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 > > --------------------------------------------------------------------- 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
