UPDATE klanten SET iban='' WHERE klantid='4837' and REPLACE(iban, ' ', '') = 'NL91RABO0157809463';
UPDATE klanten SET iban='' WHERE klantid='4829' and REPLACE(iban, ' ', '') = 'NL78RABO0135069599';
UPDATE klanten SET iban='' WHERE klantid='4823' and REPLACE(iban, ' ', '') = 'NL39RBRB0827428731';
UPDATE klanten SET iban='' WHERE klantid='4825' and REPLACE(iban, ' ', '') = 'NL63RABO0151568502';
UPDATE klanten SET iban='' WHERE klantid='4935' and REPLACE(iban, ' ', '') = 'NL77RABO0151897662';
UPDATE klanten SET iban='' WHERE klantid='4819' and REPLACE(iban, ' ', '') = 'NL24RABO0159735149';
UPDATE klanten SET iban='' WHERE klantid='4821' and REPLACE(iban, ' ', '') = 'NL75RABO0128647477';
UPDATE klanten SET iban='' WHERE klantid='4815' and REPLACE(iban, ' ', '') = 'NL69DEUT0540704598';
UPDATE klanten SET iban='' WHERE klantid='4827' and REPLACE(iban, ' ', '') = 'NL49RABO0129643068';
UPDATE klanten SET iban='' WHERE klantid='4831' and REPLACE(iban, ' ', '') = 'NL92RABO0166353108';
UPDATE klanten SET iban='' WHERE klantid='5521' and REPLACE(iban, ' ', '') = 'NL86RABO0183600592';
UPDATE klanten SET iban='' WHERE klantid='5901' and REPLACE(iban, ' ', '') = 'NL38INGB0007525857';
Output for 8.3.5
Warning: PHP Startup: Unable to load dynamic library 'sodium.so' (tried: /usr/lib/php/8.3.5/modules/sodium.so (libsodium.so.23: cannot open shared object file: No such file or directory), /usr/lib/php/8.3.5/modules/sodium.so.so (/usr/lib/php/8.3.5/modules/sodium.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0
UPDATE klanten SET iban='' WHERE klantid='4837' and REPLACE(iban, ' ', '') = 'NL91RABO0157809463';
UPDATE klanten SET iban='' WHERE klantid='4829' and REPLACE(iban, ' ', '') = 'NL78RABO0135069599';
UPDATE klanten SET iban='' WHERE klantid='4823' and REPLACE(iban, ' ', '') = 'NL39RBRB0827428731';
UPDATE klanten SET iban='' WHERE klantid='4825' and REPLACE(iban, ' ', '') = 'NL63RABO0151568502';
UPDATE klanten SET iban='' WHERE klantid='4935' and REPLACE(iban, ' ', '') = 'NL77RABO0151897662';
UPDATE klanten SET iban='' WHERE klantid='4819' and REPLACE(iban, ' ', '') = 'NL24RABO0159735149';
UPDATE klanten SET iban='' WHERE klantid='4821' and REPLACE(iban, ' ', '') = 'NL75RABO0128647477';
UPDATE klanten SET iban='' WHERE klantid='4815' and REPLACE(iban, ' ', '') = 'NL69DEUT0540704598';
UPDATE klanten SET iban='' WHERE klantid='4827' and REPLACE(iban, ' ', '') = 'NL49RABO0129643068';
UPDATE klanten SET iban='' WHERE klantid='4831' and REPLACE(iban, ' ', '') = 'NL92RABO0166353108';
UPDATE klanten SET iban='' WHERE klantid='5521' and REPLACE(iban, ' ', '') = 'NL86RABO0183600592';
UPDATE klanten SET iban='' WHERE klantid='5901' and REPLACE(iban, ' ', '') = 'NL38INGB0007525857';