Hi,
thsi can be a solution, there are others :
mysql> select substring(id,1,2), substring(id,3,length(id)) from mytable;
+---++
| substring(id,1,2) | substring(id,3,length(id)) |
+---++
| UP| 050
le via mysqldump, edit the flat file with a text editor so that all
'EN' become 'UP', then reload the modified data back into the database. A
lot more work but still do-able if there are some gotchas in the data that
you haven't told us about.
Rhino
- Original Message -
Hello,
I have a table that has a varchar column in which I need to change a prefix for
all records. Currently there are about 500 records and I did not want to do
this by hand. It looks like this:
[data here ]
UP05000
UP05001
UP05002
UP05003
The identifier has now changed to EN so each records