Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: [TIP] comments database cleanup  (Read 4467 times)

0 Members and 1 Guest are viewing this topic.

MaThIbUs

  • Contributor
  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 130
  • I rock.
    • http://mathibus.com/
[TIP] comments database cleanup
« 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
Logged
Pages: [1]   Go Up
 

Page created in 0.021 seconds with 20 queries.