Can You Use A Find & Replace Command

ghecko · #1 (**permalink**) 08-13-04, 16:19

Hi All

I have a full text field that is in a particular table. Does anyone know if there is a way to run a find and replace command on this field.

For info the field is lots of html text, and the text I want to change is a particular URL within this text.

Any syntax code would be greatly appreciated.

Thanks

PS I have PHPMyAdmin nothing else to connect.

ricker · #2 (**permalink**) 08-16-04, 15:07

You could try to update such fields using pure SQL:

Code:

UPDATE site_description_table SET site_description_field = REPLACE(site_description_field, 'http://site1.com', 'http://site2.com')
WHERE site_description_field LIKE '%http://site1.com%'

Internet Services

Web Development

Digital Marketing

Consumer Tech