Search & Replace in DB?

[Rayn]

I want to search for a line in a database and then replace it. But the prob is that its a blob with more than just that text I am searching for.. so I cannot replace it entirely.

[adrian_quah]

Rayn, i'm not too sure what u're talking abt..

from my understanding, here's my suggestion: -
1. enter search term(s)
2. display all search terms results (e.g. there are 3 records which match it)
3. click or select it...get the unique primary key for this record, e.g. it is 'A'.
4. update this record (where primary_key=='A')

Does this help? u shd reference it to ur unique primary key...if ur table doesnt have one, it should..

[ratass2002]

Have you tried to use UPDATE which can update one particular cell. http://www.mysql.com/doc/en/UPDATE.html

[dspeer]

What I would do would be to dump the contents of the table, open it up in a text editor and do a search and replace, then import the replaced text.

[ultraslacker]

As long as the text is distinct (you want to replace all occurrences of that line in the blob) then use mysql's REPLACE function. Test it first before doing the UPDATE.

SELECT REPLACE(blob_field, 'Andy Roddick won his semifinal mattch', 'Andy Roddick lost his semifinal match') FROM foo WHERE ....

[ratass2002]

ultraslacker is right, I read the question wrong.