Find and Replace in SQL database - Revision history

Smsldoo at 14:36, 25 March 2014

2014-03-25T14:36:10Z

Smsldoo at 17:37, 17 February 2012

2012-02-17T17:37:45Z

10.30.6.195 at 14:40, 8 June 2011

2011-06-08T14:40:01Z

10.30.6.195 at 14:39, 8 June 2011

2011-06-08T14:39:53Z

10.30.6.195: Created page with "If you need to find and replace a small portion of code (such as ~ to ) in a database you can use something like: update [table_name] set [field_name] = replace([..."

2011-06-08T14:38:33Z

Created page with "If you need to find and replace a small portion of code (such as ~<username> to <url>) in a database you can use something like: update [table_name] set [field_name] = replace([..."

New page

If you need to find and replace a small portion of code (such as ~<username> to <url>) in a database you can use something like:

update [table_name] set [field_name] = replace([field_name],'[string_to_find]','[string_to_replace]');

Just make sure [field_name] is set correctly on both sides. Otherwise you may overwrite data.

← Older revision		Revision as of 17:37, 17 February 2012
Line 1:		Line 1:
		+	[[Category:Knowledge]]
		+
	If you need to find and replace a small portion of code (such as ~<username> to <url>) in a database you can use something like:		If you need to find and replace a small portion of code (such as ~<username> to <url>) in a database you can use something like:

@@ Line 3: / Line 3: @@
 If you need to find and replace a small portion of code (such as ~<username> to <url>) in a database you can use something like:
-<code>
+<source lang='sql'>
 update [table_name] set [field_name] = replace([field_name],'[string_to_find]','[string_to_replace]');
-</code>
+</source>
 Just make sure [field_name] is set correctly on both sides. Otherwise you may overwrite data.