Re: substituting a certain word in all the tinytext rows in a table using SQL command

2005-05-19 Thread Philippe Poelvoorde
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 SE

Re: substituting a certain word in all the tinytext rows in a table using SQL command

2005-05-19 Thread Ian Sales (DBA)
symbulos wrote: 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? - see REPLACE here: http://dev.mysql.com/doc/mysql/en/string-functions.html - ian -- +--

substituting a certain word in all the tinytext rows in a table using SQL command

2005-05-19 Thread symbulos
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 -- symbulos - ethical services for your organisation website www.symbulos.com -- MySQL General Mailing List For