UPDATE attachments SET colname=TRIM(colname);

SELECT name FROM PRAGMA_TABLE_INFO('your_table');