Cacher is the code snippet organizer for pro developers

SET @table = 'article_lang';

SET @q1 = CONCAT('UPDATE ', @table,' SET language_id = 1000 WHERE language_id = 1');
SET @q2 = CONCAT('UPDATE ', @table,' SET language_id = 1 WHERE language_id = 2');
SET @q3 = CONCAT('UPDATE ', @table,' SET language_id = 2 WHERE language_id = 1000');

PREPARE stmt FROM @q1;
EXECUTE stmt;

PREPARE stmt FROM @q2;
EXECUTE stmt;

PREPARE stmt FROM @q3;
EXECUTE stmt;

SET @myArrayOfValue = '2,5,2,23,6,';

WHILE (LOCATE(',', @myArrayOfValue) > 0)
DO
    SET @value = ELT(1, @myArrayOfValue);
    SET @myArrayOfValue= SUBSTRING(@myArrayOfValue, LOCATE(',',@myArrayOfValue) + 1);

    INSERT INTO `EXEMPLE` VALUES(@value, 'hello');
END WHILE;