forum.coppermine-gallery.net

No Support => General discussion (no support!) => Topic started by: MaThIbUs on February 08, 2004, 09:12:42 pm

Title: [TIP] comments database cleanup
Post by: MaThIbUs on February 08, 2004, 09:12:42 pm
Assuming you use "cpg_" as a table prefix:

Code: [Select]
UPDATE `cpg_comments`
SET `msg_body` =
REPLACE(`msg_body`, '  ', ' ');


This will remove double spaces in the comments table. You can do the same to picture descriptions, keywords etc etc.

Just a small tip :)

/m_aTh!bUs