| 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 Derp | 19 Aug |
| • Re: How to loop a query that is only able to handle 1 ROW at a time? | Rob Pollock | 20 Aug |
