Hangs while doing Search/Replace

[expired user #7481]'s profile image [expired user #7481] posted 6 years ago in General Permalink

I am trying to do a search and replace on the results of a query with 7000 rows. It does a few hundred replaces and then hangs. I am using the latest HeidiSQL. 10.1.0.5464 I have to close the program to recover.

My replace is looking for " NSW" (which is at the end of a field) and replace it with nothing. ie stripping the NSW off the end of each field.

I have repeated the hanging at least four times.

Please login to leave a reply, or register at first.