mySQL - trim leading / trailing blank space from POST table's "pagetext" column

[Rik Brown]

I've been trying to run a mySQL query to trim leading and trailing blank spaces in the pagetext column of the posts table in order to clean up the presentation of the post data. I've been testing the following query on a single post:

UPDATE `post` SET `pagetext` = TRIM(pagetext) WHERE postid = '427517';

I don't see anything wrong with the query. However, it nukes the entire line of data for any specific post. Does anyone know what I'm doing wrong?

Thanks. -- Rik