in reply to DBI mysql substring_index syntax error

If you print the string out you'll see it has been modified and no longer matches what you're using in MySql, instead:

my $query = 'SELECT DISTINCT SUBSTRING_INDEX(SUBSTRING_INDEX(path, "\\
+\\", -2), "\\\\", 1) AS dir FROM files';

[download]

Replies are listed 'Best First'.
Re^2: DBI mysql substring_index syntax error
by Rodster001 (Pilgrim) on Oct 22, 2014 at 04:19 UTC
    Got it, changed to: 
    SELECT DISTINCT SUBSTRING_INDEX(SUBSTRING_INDEX(i.path, '\\\\', -2) , '\\\\', 1) AS dir
    Thanks!
[reply]

In Section Seekers of Perl Wisdom