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

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

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