use jbpg;

load xml local infile '/home/garth/public_html/jbpg/jbpg_-_photo_album_01/index.xml' into table jbpg.photoalbum rows identified by '<image>';
update `jbpg`.`photoalbum` set `itemOriginalPath` = replace (`itemOriginalPath`,char(9)," ");
update `jbpg`.`photoalbum` set `itemOriginalPath` = replace (`itemOriginalPath`,char(10)," ");
update `jbpg`.`photoalbum` set `itemOriginalPath` = replace (`itemOriginalPath`,char(13)," ");
update `jbpg`.`photoalbum` set `itemOriginalPath` = ltrim (`itemOriginalPath`);
update `jbpg`.`photoalbum` set `itemOriginalPath` = rtrim (`itemOriginalPath`);
update `jbpg`.`photoalbum` set `itemWidth` = replace (`itemWidth`,char(9)," ");
update `jbpg`.`photoalbum` set `itemWidth` = replace (`itemWidth`,char(10)," ");
update `jbpg`.`photoalbum` set `itemWidth` = replace (`itemWidth`,char(13)," ");
update `jbpg`.`photoalbum` set `itemWidth` = ltrim (`itemWidth`);
update `jbpg`.`photoalbum` set `itemWidth` = rtrim (`itemWidth`);
update `jbpg`.`photoalbum` set `itemHeight` = replace (`itemHeight`,char(9)," ");
update `jbpg`.`photoalbum` set `itemHeight` = replace (`itemHeight`,char(10)," ");
update `jbpg`.`photoalbum` set `itemHeight` = replace (`itemHeight`,char(13)," ");
update `jbpg`.`photoalbum` set `itemHeight` = ltrim (`itemHeight`);
update `jbpg`.`photoalbum` set `itemHeight` = rtrim (`itemHeight`);
update `jbpg`.`photoalbum` set `itemCaption` = replace (`itemCaption`,char(9)," ");
update `jbpg`.`photoalbum` set `itemCaption` = replace (`itemCaption`,char(10)," ");
update `jbpg`.`photoalbum` set `itemCaption` = replace (`itemCaption`,char(13)," ");
update `jbpg`.`photoalbum` set `itemCaption` = ltrim (`itemCaption`);
update `jbpg`.`photoalbum` set `itemCaption` = rtrim (`itemCaption`);
update `jbpg`.`photoalbum` set `itemCaption` = replace (`itemCaption`,'\"',"^");