I am moving my modules from the old template to the new one on Joomla 4.
DB Replacer is an excellent tool for doing this, I am using version 7.5.0.
However, I want to change the 'right' position to sidebar-right. This worked fine for the first 100 rights. However for the next 100 I had to add the where clause position != "sidebar-right", which selected the next 100 but clicking on the green replace button didn't cause anything to happen.