set @xml = '<?xml version="1.0"?><search><group><field name="imageid" relation="oneof"><listitem>47901</listitem><listitem>47902</listitem><listitem>11827</listitem></field></group></search>';
select extractValue(@xml,'/search/group/field/listitem');

CREATE PROCEDURE test
BEGIN
  DECLARE xml TEXT;
  DECLARE entries INT;
  DECLARE entry INT DEFAULT 1;
  SET xml= '<a><b>Sakila</b> <b>TEST</b></a>'
  SET entries= ExtractValue(xml, count('/a/b'));
  WHILE entry <= entries DO
    BEGIN
      DECLARE val VARCHAR(255);
      SET val= ExtractValues(xml, '/a/b[$entry]');
      -- do INSERT into a table here, or whatever else you need
    SET entry= entry + 1;
    END;
  END WHILE;
END