symbulos wrote:
Dear friend,
Is it possible to substitute, using SQL command, a certain word with another
word in all the field in all the rows (tinytext) within a certain table?
Thanks in advance
look for REPLACE :
http://dev.mysql.com/doc/mysql/en/string-functions.html
UPDATE ..... FROM .... SET field=REPLACE(field,'plop','foo');
--
Philippe Poelvoorde
COS Trading Ltd.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
