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

[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 General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]