How To: Find And Replace

[XiRoCCo]

Hi –

Using SQLyog v5.11 (free), I need to run a 'search and replace' to replace a particular character across an entire database consisting of 88 tables. How would I go about doing this, or where would I find instructions for doing this? I tried the Help docs, but just could not find it.

Thanks,

–Kevin

[peterlaursen]

I think the easiest way would be to export the database, 'search and replace all' in an editor and import!

It must be a text editor not a word processor! If the file is too big for Notepad, PSpad is a good free one.

But you will of course have to be sure that every instance of that character shall be changed!

BTW: you should update SQLyog!

[XiRoCCo]

peterlaursen wrote on Jul 25 2006, 07:07 PM:

I think the easiest way would be to export the database, 'search and replace all' in an editor and import!

It must be a text editor not a word processor! If the file is too big for Notepad, PSpad is a good free one.

But you will of course have to be sure that every instance of that character shall be changed!

BTW: you should update SQLyog!

thanks — i use UltraEdit32 – a brilliant text editor. i considered exporting and reimporting and now see that it's probably the easiest way to accomplish this.

thanks again

–kevin

[Richard J Lacroix]

XiRoCCo wrote on Jul 28 2006, 02:54 PM:

thanks — i use UltraEdit32 – a brilliant text editor. i considered exporting and reimporting and now see that it's probably the easiest way to accomplish this.

thanks again

–kevin

😮

That's doing it the hard way, try this in SQLyog:

update [table_name] set [field_name] = replace([field_name],'[string_to_find]','[string_to_replace]');

[Author]

Posts