[notshowbiz]

Alright so I'm executing SELECT FROM and UPDATE SET in one command. Both are storing the results and freeing results before reaching each other. When I execute UPDATE SET first, SELECT FROM ceases to work and when I execute SELECT FROM first, UPDATE SET works fine but changes the second single character in the update to "P" consistently. IT DOES NOT DO THIS IF EXECUTED FIRST. Very strange issue, any answers??