search & replace string in mysql

by Ramya 2010-04-07 14:38:44

search & replace string in mysql:

To find & replace string in mysql use "update" as,
update tablename set fieldname = replace(fieldname,'search string','replace with')


Example:
update test set description = replace(description,'”','"')


update clipart set description = replace(description,'”','"')

Tagged in:

957
like
0
dislike
0
mail
flag

You must LOGIN to add comments