Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Hangs while doing Search/Replace

dafi's profile image dafi posted 1 year 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. 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.