Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- Good Man
November 3, 2006, 9:56 pm
rate this thread
If I have a "Filename" column in a database, and I want to grab the
EXTENSION of this filename... can I do it in a query using REGEXP or
I've got this going:
"SELECT f.FileID,f.FileName,f.FileName REGEXP '.+\.([^.]+)$' AS FileExt
FROM ProjFiles f
But my resulting "FileExt" column just shows a '1' (meaning that yes, a
file extension was found).
Instead of getting a "yes/no" answer from my regexp, can I actually get
the file extension itself?
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum