[snip] It may be a little more complicated then I made it out to be. I am just trying to pull out the file extension but there were some conditions I did not list. [/snip]
Thank you for that update, would have been good to have from the start.
SELECT SUBSTRING_INDEX('my.doc','.',-1)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[email protected]
