Trying to do something to manipulate a path e.g.
How can I cut the trailing slash as it's an escaping character??
I'm trying this:
SELECT TRIM(TRAILING `n` FROM `bunion`);
and getting 'bunio'
But if I try this:
SELECT TRIM(TRAILING `\` FROM 'C:\path\to\somewhere\');
It doesn't even run
And nor does this:
SELECT TRIM(TRAILING `\\` FROM 'C:\\path\\to\\somewhere\\');