mysql query to remove ".jpg" mysql query to remove ".jpg"
 

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]

Main Menu

mysql query to remove ".jpg"

Started by bit bit spears, July 01, 2005, 08:57:40 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Print
Go Down Pages1
User actions

bit bit spears

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! :)

Nibbler

#1
July 01, 2005, 03:31:43 PM
Code Select
TRIM(TRAILING '.jpg' FROM filename)

bit bit spears

#2
July 02, 2005, 01:28:15 AM
thank you! :D
Print
Go Up Pages1
User actions