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?
|