Wednesday, May 14, 2008

SQL Updating certain pattern of text in MySQL

There are a way to update a text in some database with certain pattern. Today I get a case regarding this problem. In order to update a content in a column of a table, you can use the following command:

mysql> update bodycontent SET body = REPLACE ( `body` ,'','arie.ganten');

The above query will update table bodycontent, body column which content is, to

No comments: