View Full Version : replacing one character

09-10-2006, 11:56 PM
how can i replace one character in with another, in any row.. if it can be done even in any table:)

like you would do 'find and replace' in a very large text document (that is the way im doing it now... export whole base, delete it, replace characters in dreamweaver and import base back...)

i am doing this because of characters.. which are not part of US alphabet. i would NOT like to change encoding - it brings a lot of other problems with it..


09-11-2006, 01:10 AM
Write an update query and use the replace function. (http://dev.mysql.com/doc/refman/4.1/en/string-functions.html)