Re: change data prefix query

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

Re: change data prefix query

This query (or something like it) should do the job for you: update temp11 set description = replace(description, 'EN', 'UP'); Naturally, you need to change 'temp11' to your table name and 'description' to the name of the column containing the data you want to change. The replace() function is do