mysql query to remove ".jpg"

[bit bit spears]

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]

Code Select Expand

TRIM(TRAILING '.jpg' FROM filename)

[bit bit spears]

thank you!