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
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 Gen
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
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 sever
