Why does following query run on MySQL 5.5 but will not run in WPdatatable?

SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(w.address,';',1),':',-1) AS fieldname1,

SUBSTRING_INDEX(SUBSTRING_INDEX(w.address,';',2),':',-1) AS fieldvalue1,

SUBSTRING_INDEX(SUBSTRING_INDEX(w.address,';',3),':',-1) AS fieldname2,

SUBSTRING_INDEX(SUBSTRING_INDEX(w.address,';',4),':',-1) AS fieldvalue2,

SUBSTRING_INDEX(SUBSTRING_INDEX(w.address,';',5),':',-1) AS fieldname3,

SUBSTRING_INDEX(SUBSTRING_INDEX(w.address,';',6),':',-1) AS fieldvalue3,

SUBSTRING_INDEX(SUBSTRING_INDEX(w.address,';',7),':',-1) AS fieldname4,

SUBSTRING_INDEX(SUBSTRING_INDEX(w.address,';',8),':',-1) AS fieldvalue4,

SUBSTRING_INDEX(SUBSTRING_INDEX(w.address,';',9),':',-1) AS fieldname5,

SUBSTRING_INDEX(SUBSTRING_INDEX(w.address,';',10),':',-1) AS fieldvalue5

FROM KUEPbFoTcbaccounting_vc_manager w

I get your "white screen of death"

Thanks.  The view approach worked.  However, now I can't get the report builder to read the resultant file.  I keep getting an "illegal name character" error when Microsoft Word 2010 tries to open the document files.  I have changed the column name several times and still receive the error.  I named the column "benefactor" and used ${benefactor} in the report.  When I remove that column from the template the letters will open.

Thanks.  You are correct - there was an & character.  Looking forward to the correction.