The following select statement works just fine:
select uid, member, memberType from users where uID > 31650;
This update statement does not work:
update users set memberType = member where memberType is null;
Unknown column, 'memberType' in field list.
I'm confused how memberType shows up and yet it says it doesn't exist in the update. Can someone show me what I'm doing wrong?