MYSQL mediumblob

Hi, I need some help desperately! is it possible to move a mediumblob data piece from one table in a database to another table in the same database? and if so, how do u do it? i thought it wud be simply doing a select statement first and then placing it into variables then inserting the variable into the table. but i keep gettin this:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘Ë2é ´ÖXacŵ F<ÁUu‰ïûA€ïûø¾çy(¥ú@”šòZsyÞw"pâ|í’ at line 1.

PLEASE HELP!!:upset: