Thanks a lot. So, the query to use would be: update the_table set the_text=replace(the_text, 'tekst', 'text') where the_text like '%tekst%'
Is that correct? --- In [email protected], Pete <[EMAIL PROTECTED]> wrote: > > 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 > 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/
