Problems? Is your data what you think it is? | |
PerlMonks |
Re^2: DBI mysql substring_index syntax errorby Rodster001 (Pilgrim) |
on Oct 22, 2014 at 04:19 UTC ( [id://1104631]=note: print w/replies, xml ) | Need Help?? |
Got it, changed to:
SELECT DISTINCT SUBSTRING_INDEX(SUBSTRING_INDEX(i.path, '\\\\', -2) , '\\\\', 1) AS dirThanks!
In Section
Seekers of Perl Wisdom
|
|