Re[2]: Update a portion of text in a field

2004-09-28 Thread Jacques Jocelyn
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

Re[2]: Update field conditionally

2004-03-09 Thread Richard Davey
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

Re[2]: Update

2001-09-21 Thread Igbar Foosenhopper
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);