you said the following in a private message:
I figured it out. I added " AS pageDesc," after the "LEFT(colName, number)" and used the pageDesc binding. Somehow not using the AS pageDesc worked in MySQL.
If you are able to figure out a problem on your own, it is best to add that info as a public message rather than private.