Advanced search  

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

Pages: [1]   Go Down

Author Topic: [TIP] comments database cleanup  (Read 4479 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
« previous next »
 

Page created in 0.015 seconds with 20 queries.