|
|
|
| No such thing as a small change | |
| 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
|
|
||||||||||||||||||||||