Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2004
    Posts
    1

    Lightbulb Unanswered: Can You Use A Find & Replace Command

    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.

  2. #2
    Join Date
    Aug 2004
    Posts
    4
    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%'

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •