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

News:

CPG Release 1.6.27
change DB IP storage fields to accommodate IPv6 addresses
remove use of E_STRICT (PHP 8.4 deprecated)
update README to reflect new website
align code with new .com CPG website
correct deprecation in captcha

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