List:General Discussion« Previous MessageNext Message »
From:Incarus Derp Date:August 19 2012 9:23pm
Subject:How to loop a query that is only able to handle 1 ROW at a time?
View as plain text  
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;

Thread
How to loop a query that is only able to handle 1 ROW at a time?Incarus Derp19 Aug
  • Re: How to loop a query that is only able to handle 1 ROW at a time?Rob Pollock20 Aug