Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Search and Replace text within the database

Quote Reply
Search and Replace text within the database
I have some font tages like <b></b> that I would like to replace with . I'd rather not have to edit each link seperately. Is there some way to do a "Search and Replace" within a table?

If so, can you spell it out for me using the above scenario? (turning <b> into )

Thanks!

Last edited by:

Evoir: Jul 22, 2002, 12:48 PM
Quote Reply
Re: [Evoir] Searcha and Replace text within the database In reply to
UPDATE Links SET Field = REPLACE(Field, '<b>', '[b]')

...then the same for </b> [/b]

Last edited by:

Paul: Jul 22, 2002, 12:34 PM
Quote Reply
Re: [Paul] Searcha and Replace text within the database In reply to
Thanks Paul, but how do I even do that.... do I use phpmyadmin? where do I type what you wrote. (okok I am a little slow. I am not a programmer.)
Quote Reply
Re: [Evoir] Searcha and Replace text within the database In reply to
Yup phpmyadmin or mysqlman from the links sql admin panel (SQL Monitor).

Just change the two occurances of "Field" to the column name you are updating.
Quote Reply
Re: [Paul] Searcha and Replace text within the database In reply to
Thank you. Worked like a charm. I will submit to the resources area.

Last edited by:

Evoir: Jul 22, 2002, 12:48 PM