Print Page - mysql query to remove ".jpg"

Title: mysql query to remove ".jpg"
Post by: bit bit spears 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! :)

Title: Re: mysql query to remove ".jpg"
Post by: Nibbler on July 01, 2005, 03:31:43 PM

Code Select

TRIM(TRAILING '.jpg' FROM filename)

Title: Re: mysql query to remove ".jpg"
Post by: bit bit spears on July 02, 2005, 01:28:15 AM

thank you! :D

coppermine-gallery.com/forum

Support => Older/other versions => cpg1.3.x Support => Topic started by: bit bit spears on July 01, 2005, 08:57:40 AM