Hello Daniel,
DK MySQL has a 'replace' function for this:
DK update table X set field1=replace(field1, 'functionalities',
DK 'functionality') where tableid=1;
DK http://dev.mysql.com/doc/mysql/en/String_functions.html
Awesome !
Got it, thanks
Best regards,
Jacques Jocelyn
--
MySQL
Hello Terry,
Tuesday, March 9, 2004, 6:25:00 PM, you wrote:
TR Good point, Richard. I was perhaps in a little bit too much of a hurry
TR putting that together, and didn't even consider that!
No worries. One other thought that occurred to me that might help with
the original problem is as
JSaur,
Hello Igbar,
thank you for your script.
Bud I need to change just word with. Woman with hammer was just example.
There is text about 1000 words in one fied, and I need to change just a
short string.
I show you another example.
CREATE TABLE my_table(c1 int NOT NULL PRIMARY KEY, c2 blob);