I have a two line query that is only able to handle 1 row per execution. Could any of you give me some insight on how I could loop this per every single row in the table? The query in question is:
SELECT PREG_REPLACE('/TeXT/', '' , Ivet) FROM `DB1`.`TB1` INTO @VAR12; UPDATE `TB1` SET Ivet = @VAR12;