Sorry Jay,
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.
-Aaron
On Thu, Jun 10, 2010 at 9:28 AM, Jay Blanchard <jblanch...@pocket.com> wrote:
>
> 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/mysql?unsub=arch...@jab.org
