On 10/06/2010 16:55, Aaron Savage wrote:
I am looking for some guidance on creating a substring query. I have
a column that stores a path to a file. I would like to extract that
file extension and that is it and display it on my results. However,
the paths are different lengths and some extensions are 3 letter and
some are 4, eq 'html'. The only common they all have is the period
before the extension. Anyone created a nested substring query that
can do what I am looking to do?
SUBSTRING_INDEX should do what you want.
SELECT SUBSTRING_INDEX('myfile.path','.',-1)
=> 'path'
SELECT SUBSTRING_INDEX('myfile.pth','.',-1)
=> 'pth'
or, in a version that's closer to real life usage:
SELECT SUBSTRING_INDEX(myfield,'.',-1) from mytable
http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_substring-index
Mark
--
http://mark.goodge.co.uk
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
