http://www.mdj.us/ A simple way to perform a substring replace in MySQL. With a basic form to build your own query. en http://www.mdj.us/web-development/mysql/mysql-substring-replace-with-simple-query-builder/#comment-1554 Mon, 12 Dec 2011 17:04:50 +0000 http://www.mdj.us/web-development/mysql/mysql-substring-replace-with-simple-query-builder/#comment-1553 Sun, 11 Dec 2011 18:34:07 +0000
You want to use concat.

[sql]UPDATE table SET field=concat(field,'string to append');[/sql]

That should add your string to the end of each record. Totally untested however, on my phone watching the football game right now :-)]]> http://www.mdj.us/web-development/mysql/mysql-substring-replace-with-simple-query-builder/#comment-1552 Sun, 11 Dec 2011 16:02:53 +0000
It is a great example I'm looking for!

Besides, if I want to adding a string at the end of each record for a table. What should I do on the SQL?

Thanks]]> http://www.mdj.us/web-development/mysql/mysql-substring-replace-with-simple-query-builder/#comment-1549 Sat, 10 Dec 2011 15:39:33 +0000
The field is the column name you'd like to perform the find & replace on.

For example, say you have a table for a simple blog called "Posts", and within that table there is an id column, a post_title column, a postdate column, and a post_content column (this contains the actual blog post content). The table would look something like this;

http://www.mdj.us/images/db-example.png

When you say the whole database, you're talking about multiple tables & columns like that, are you sure that's what you're looking for?

If I really needed to perform that global of a find & replace, I would probably write a PHP script to loop through all the fields I wanted to do a find & replace on.]]> http://www.mdj.us/web-development/mysql/mysql-substring-replace-with-simple-query-builder/#comment-1548 Sat, 10 Dec 2011 13:16:01 +0000
What do i stick in 'field name']]> http://www.mdj.us/web-development/mysql/mysql-substring-replace-with-simple-query-builder/#comment-1545 Thu, 08 Dec 2011 16:13:43 +0000 http://www.mdj.us/web-development/mysql/mysql-substring-replace-with-simple-query-builder/#comment-1372 Sun, 10 Apr 2011 02:45:09 +0000 http://www.mdj.us/web-development/mysql/mysql-substring-replace-with-simple-query-builder/#comment-1353 Sun, 20 Mar 2011 17:44:22 +0000 http://wiki.nisi.ro/2011/03/how-to-replace-substring-in-mysql-table-field/]]> http://www.mdj.us/web-development/mysql/mysql-substring-replace-with-simple-query-builder/#comment-1271 Fri, 22 Oct 2010 21:51:33 +0000 http://www.mdj.us/web-development/mysql/mysql-substring-replace-with-simple-query-builder/#comment-1264 Thu, 07 Oct 2010 07:06:27 +0000