SQL find and replace query

[Seraphim]

Hello

I have a small problem with my SQL database. I still have parts from old url's in my forum posts. Instead of good 3000 post by hand to change a little, I could write SQL command, which to me all the old url's are replaced by new.

I've no idea how I should write this command ...

For eg:

REPLACE INTO `forum_posts` SET `post` = 'up-space.theplayers.ch'
WHERE `post` = 'fini.techarena.in / upspace'

This is the actual spirit quite close but not exact.

I want from the table in the column forum_posts post all entries "fini.techarena.in/upspace" by "up-space.theplayers.ch replace.

Can anyone of you help me?

[Zenon]

Hi,

Try this code:

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

[PreatORiAn]

Hi,

The following query to the SQL server to generate for SP 2.

Create FindReplace stored procedure

create PROCEDURE FindReplace 
( 
@ TABLE VARCHAR (200), 
@ Field VARCHAR (200), 
@ WHERE VARCHAR (100), 
@ Find VARCHAR (500), 
@ REPLACE VARCHAR (500) 
) 
AS 
DECLARE @ query VARCHAR (8000) 
SET @ query = 'UPDATE' + @ TABLE + 
'SET' + @ Field + '= REPLACE (CONVERT (varchar (8000),' 
+ @ Field +'),''' + @ Find +''',''' + @ REPLACE +''')' 
IF (@ WHERE <>'') 
SET @ query = @ query + 'WHERE' + @ WHERE 

EXECUTE (@ query) 
GO

[Mac-Imagery]

In order to search and replace text before sending it over to the SQLi buffer, use the following in your ~ /. Emacs:

(Require 'sql)

 (define-key sql-mode-map (kbd "Cc Cb") 'my-sql-replace-and-send) 
    
      (defcustom my-sql-replacements 
        '(("# USER # "." 'Crueger' ")) 
        "Strings to replace." 
        : type '(repeat (cons (string: tag "search") (string: tag "replace ")))) 
    
      (defun my-sql-replace-and-send () 
        (interactive) 
        (let * ((start (save-excursion 
		        (backward-paragraph) 
		        (point))) 
	       (end (save-excursion 
		      (forward-paragraph) 
		      (point))) 
	       (statement (buffer-substring start end)) 
	       (things my-sql-replacements) 
	       (buf sql-buffer)) 
	  (with-temp-buffer 
	    (insert statement) 
	    (dolist (thing things) 
	      (goto-char (point-min)) 
	      (while (search-forward (car thing) nil t) 
	        (replace-match (cdr thing)))) 
	    (let ((sql-buffer buf)) 
	      (sql-send-buffer )))))