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: mysql query to remove ".jpg"  (Read 2701 times)

0 Members and 1 Guest are viewing this topic.

bit bit spears

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 240
    • TangibleBrit.com
mysql query to remove ".jpg"
« on: July 01, 2005, 08:57:40 am »
Hi i was wandering if there was a query in mysql that i could use to remove the image's filepath ".jpg" part and leave just the filename.

thanks in advance! :)
Logged

Nibbler

  • Guest
Re: mysql query to remove ".jpg"
« Reply #1 on: July 01, 2005, 03:31:43 pm »
Code: [Select]
TRIM(TRAILING '.jpg' FROM filename)
Logged

bit bit spears

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 240
    • TangibleBrit.com
Re: mysql query to remove ".jpg"
« Reply #2 on: July 02, 2005, 01:28:15 am »
thank you! :D
Logged
Pages: [1]   Go Up
« previous next »
 

Page created in 0.015 seconds with 15 queries.