in reply to Re: DBI mysql substring_index syntax errorin thread DBI mysql substring_index syntax error
SELECT DISTINCT SUBSTRING_INDEX(SUBSTRING_INDEX(i.path, '\\\\', -2) , '\\\\', 1) AS dir