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

News:

CPG Release 1.6.28
added submissions from {406man}
cleaned up a few PHP (8.4) deprecations
fixed PHP deprecation in calendar
removed security vulnerability
(please upgrade when 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