[TIP] comments database cleanup [TIP] comments database cleanup
 

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Main Menu

[TIP] comments database cleanup

Started by MaThIbUs, February 08, 2004, 09:12:42 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Print
Go Down Pages1
User actions

MaThIbUs

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
Print
Go Up Pages1
User actions