In message <[EMAIL PROTECTED]>, agneady <[EMAIL PROTECTED]> writes >Hello, > >Suppose I have a field named "the_text" in a MySQL table named >"the_table", containing the following data: > >row1: "some tekst" >row2: "some other tekst" >row3: "yet some other tekst" > >Now, I want to run a replace query to replace "tekst" with "text" >without changing the rest of the field contents. How can ths be done?
You need the MySQL REPLACE() function. http://dev.mysql.com/doc/refman/5.0/en/string-functions.html Don't confuse this with the replace command... -- Pete Clark Andalucia in Sunny Southern Spain http://www.hotcosta.com/comm_1.htm ------------------------ Yahoo! Groups Sponsor --------------------~--> Great things are happening at Yahoo! Groups. See the new email design. http://us.click.yahoo.com/SktRrD/hOaOAA/yQLSAA/CefplB/TM --------------------------------------------------------------------~-> The php_mysql group is dedicated to learn more about the PHP/MySQL web database possibilities through group learning. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php_mysql/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
