[TIP] comments database cleanup

[MaThIbUs]

Assuming you use "cpg_" as a table prefix:

Code Select Expand

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