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

News:

CPG Release 1.6.28
added submissions from {406man}
cleaned up a few PHP (8.4) deprecations
fixed PHP deprecation in calendar
removed security vulnerability
(please upgrade when possible)

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