Re: How to edit part of a field?

Wow - so easy! What a dork. Thanks guys. :) :) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: How to edit part of a field?

On 28/06/05, Brian Dunning <[EMAIL PROTECTED]> wrote: > Hi all - > > I have an urgent need to update several million records. There is a > URL stored in a MySQL 'text' field. Many of the records contain > "1234" like this: > > http://www.domain.com?etc=etc&arg=1234&etc=etc > > Any occurence of "

Re: How to edit part of a field?

Selon Brian Dunning <[EMAIL PROTECTED]>: > Hi all - > > I have an urgent need to update several million records. There is a > URL stored in a MySQL 'text' field. Many of the records contain > "1234" like this: > > http://www.domain.com?etc=etc&arg=1234&etc=etc > > Any occurence of "1234" has to be

How to edit part of a field?

Hi all - I have an urgent need to update several million records. There is a URL stored in a MySQL 'text' field. Many of the records contain "1234" like this: http://www.domain.com?etc=etc&arg=1234&etc=etc Any occurence of "1234" has to be changed to "5678" like this: http://www.domain.co