View Single Post
Old 08-19-2008, 09:20 AM  
Pics Traffic
Confirmed User
 
Pics Traffic's Avatar
 
Industry Role:
Join Date: Jun 2004
Location: Europe
Posts: 3,055
MySql query help needed asap.

I have a field in db that is 10 char long and its random characters.
I need to either truncate every one of them to 9 chars or replace last characters with "xx"

Is there way to do it with query that will update all rows of data?
Pics Traffic is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote