Re: Update a portion of text in a field

2004-09-29 Thread Aman Raheja
You'll get many results if you search for "mysql update replace" in google. You'd be using a combo of update-replace to do what you need. Aman Raheja Jacques Jocelyn wrote: Hello mysql, Something I have been thinking about without any clue on how I can achieve it. I know how to update a field w

Re: Update a portion of text in a field

2004-09-28 Thread Daniel Kasak
Jacques Jocelyn wrote: Hello mysql, Something I have been thinking about without any clue on how I can achieve it. I know how to update a field with "update table X set field1='My Text' where tableid = 1" Now, say I have in a table X, the field1 with the value : 'I have been searching that func