my question here is where is the syntax error.
and "SET @CHARACTERS := 'charlk';" points to the database. not the specific table i want it to point at (which is "characters") where it will find the 'account' column.
so should it not be "SET @CHARACTERS := 'characters';" ?
this is how i learn, so please be patient you have been a great help so far