[snip] Here is what I came up with. select substring(substring_index(myfile,'.',-2),1,4) AS MyColumn from mydatabase group by MyColumn;
That appears to yield what I need. I just need to filter out the results that do not have an extension. [/snip] You can exclude results that do not have a period in them if this is the only period -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
