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 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 functionalities for several days' and I would like to replace 'functionalities' by 'functionality'
Would anyone knows how to replace JUST one word or a part of a text in a field without using an external program ?
Please advise,
thanks
Best regards,
Jacques Jocelyn
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
