News:

CRITICAL UPGRADE CPG RELEASE 1.6.30
Version 1.6.30 removes a serious security issue that could allow unauthorized access to modify your site. Upgrade as soon as possible.

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