does not work in version 3.3.5?
SELECT guid, name, race, class, level, zone AS zoneid, map AS mapid, online, gender, totaltime, account AS acct, logout_time AS timestamp, health, power1, power2, power3, power4, power5, power6, power7, SUBSTRING_INDEX(SUBSTRING_INDEX(data, ' ', 1011), ' ', -1) AS xp, SUBSTRING_INDEX(SUBSTRING_INDEX(data, ' ', 1650), ' ', -1) AS arenaPoints, SUBSTRING_INDEX(SUBSTRING_INDEX(data, ' ', 1649), ' ', -1) AS totalHonorPoints, SUBSTRING_INDEX(SUBSTRING_INDEX(data, ' ', 1603), ' ', -1) AS totalKills FROM characters WHERE guid = '40'
Unknown column 'data' in 'field list'