Hi
Does anybody know how to change a part string in mysql database?
using:
їcode]update sales
set ID = replace(ID,'from','to')
where 1ї/code]
I am wanting to change the following:
CS119 to 119L
CS221 to 221L
etc etc,
there are over 500 to change and it would take forever to change them manually
Thanks.
String Replace
Moderator: General Moderators
I think you should read the String Functions chapter in MySQL documentation -> http://dev.mysql.com/doc/mysql/en/String_functions.html